Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    3. Replies
      3
      Views
      2.2k
      3

    4. AliGW

    2. COUNTIF Problem 16

      • endl3ss
    3. Replies
      16
      Views
      2.2k
      16

    4. AliGW

    2. Sum non-consecutive/contiguous cells by Month and Year 5

      • tac_79
    3. Replies
      5
      Views
      2.2k
      5

    4. tac_79

    2. Can A Vlookup W/Search Function Work On A Substring of Text? 6

      • MexicoGuy
    3. Replies
      6
      Views
      2.2k
      6

    4. FDibbins

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

      • Rovi
      • Rovi
    3. Replies
      8
      Views
      2.2k
      8

    4. Rovi

    2. Petty Cash Template - Keep cell blank until data entered 3

      • Chaffrin
    3. Replies
      3
      Views
      2.2k
      3

    4. royUK

    2. YTD using dynamic spilled array 11

      • MatthewHart
    3. Replies
      11
      Views
      2.1k
      11

    4. AliGW

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

      • shinobi09
    3. Replies
      6
      Views
      2.1k
      6

    4. Grimes0332

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

      • Elusive
    3. Replies
      9
      Views
      2.1k
      9

    4. sktneer

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

      • blade671
    3. Replies
      10
      Views
      2.1k
      10

    4. blade671

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

      • sathishsusa
    3. Replies
      15
      Views
      2.1k
      15

    4. Joris Moerings

    2. Auto Add/Subtract 10

      • JJeffery99
    3. Replies
      10
      Views
      2.1k
      10

    4. yongle

    2. IFERROR VLOOKUP MAX value 8

      • ItsSugarBunny
    3. Replies
      8
      Views
      2.1k
      8

    4. AliGW

    2. Positive Correlation but Negative correlation in Regression. 4

      • Jontini
    3. Replies
      4
      Views
      2.1k
      4

    4. pike

    2. Sumif with Offset 2

      • jvalente
    3. Replies
      2
      Views
      2.1k
      2

    4. jvalente

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

      • paul789
    3. Replies
      15
      Views
      2.1k
      15

    4. AliGW

    2. Sumproduct with blank criteria 7

      • DaneMark
    3. Replies
      7
      Views
      2.1k
      7

    4. XOR LX

    2. Combine Large and Sumif - Array formula 4

      • London.London
    3. Replies
      4
      Views
      2.1k
      4

    4. London.London

    2. alert levels 12

      • zohar
    3. Replies
      12
      Views
      2.1k
      12

    4. zohar

    2. Replace a row number with a dynamic cell value 3

      • acat
      • acat
    3. Replies
      3
      Views
      2k
      3

    4. Carim

Label

Display Options