Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Excel Formula Sum of Minimum Values 10

      • GIRISHBISHT
    2. Replies
      10
      Views
      2k
      10
    3. pike

    1. Archery scorecard for Top 4 Female scores then the Top 8 scores 6

      • shinobi09
    2. Replies
      6
      Views
      2k
      6
    3. Grimes0332

    1. Last non-empty cell in the column based on three header rows that are criteria 16

      • rehan kazi
    2. Replies
      16
      Views
      2k
      16
    3. rehan kazi

    1. vlookup cell values only if date on adjacent column less than requested. INDEX/MATCH? 9

      • Elusive
    2. Replies
      9
      Views
      2k
      9
    3. sktneer

    1. Sumif with Offset 2

      • jvalente
    2. Replies
      2
      Views
      2k
      2
    3. jvalente

    1. Trying to pull specific data from sheet1 to other sheets if it meets criteria 10

      • blade671
    2. Replies
      10
      Views
      2k
      10
    3. blade671

    1. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    2. Replies
      3
      Views
      2k
      3
    3. AliGW

    1. select by data validation list to highlight the cells 15

      • sathishsusa
    2. Replies
      15
      Views
      1.9k
      15
    3. Joris Moerings

    1. Positive Correlation but Negative correlation in Regression. 4

      • Jontini
    2. Replies
      4
      Views
      1.9k
      4
    3. pike

    1. xlookup multiple criteria? 2

      • browncoat
    2. Replies
      2
      Views
      1.9k
      2
    3. gyankosh.net

    1. Running count of occurrence in list using array formula with spill range 4

      • Range Rover
    2. Replies
      4
      Views
      1.9k
      4
    3. Range Rover

    1. YTD using dynamic spilled array 11

      • MatthewHart
    2. Replies
      11
      Views
      1.9k
      11
    3. AliGW

    1. Using a value from a cell inside a formula 8

      • yogeshtalks
    2. Replies
      8
      Views
      1.9k
      8
    3. NBVC

    1. VBA to insert IF formula to convert dates to DD/MM/YYYY 8

      • Rovi
      • Rovi
    2. Replies
      8
      Views
      1.9k
      8
    3. Rovi

    1. Highlight largest value cell in range based on other columns 15

      • paul789
    2. Replies
      15
      Views
      1.9k
      15
    3. AliGW

    1. Count number of dates by month 4

      • DezB
      • DezB
    2. Replies
      4
      Views
      1.8k
      4
    3. royUK

    1. alert levels 12

      • zohar
    2. Replies
      12
      Views
      1.8k
      12
    3. zohar

    1. Sumproduct with blank criteria 7

      • DaneMark
    2. Replies
      7
      Views
      1.8k
      7
    3. XOR LX

    1. if isnumber search and iserror vlookup index match - used together. 2

      • Emile du Toit
    2. Replies
      2
      Views
      1.8k
      2
    3. Emile du Toit

    1. Need help with  VLOOKUP by WEEKNUM 11

      • chobart46
    2. Replies
      11
      Views
      1.8k
      11
    3. Carim

Display Options