Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. INCREMENT NUMERICAL STRING BY 1 17

      • Garth Lean
    2. Replies
      17
      Views
      2.4k
      17
    3. MandyRead

    1. Auto Add/Subtract 10

      • JJeffery99
    2. Replies
      10
      Views
      2.4k
      10
    3. yongle

    1. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    2. Replies
      21
      Views
      2.3k
      21
    3. LearningXL

    1. Use COUNTIF on column that contains TRIM formula 3

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

    1. Excel Formula Sum of Minimum Values 10

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

    1. Istext 3

    2. Replies
      3
      Views
      2.3k
      3
    3. cytop

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

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

    1. Highlight if Cell contains asterisk(*) 8

      • Anna Mary
    2. Replies
      8
      Views
      2.3k
      8
    3. alansidman

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

      • MexicoGuy
    2. Replies
      6
      Views
      2.3k
      6
    3. FDibbins

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

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

    1. COUNTIF Problem 16

      • endl3ss
    2. Replies
      16
      Views
      2.3k
      16
    3. AliGW

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

      • tac_79
    2. Replies
      5
      Views
      2.3k
      5
    3. tac_79

    1. YTD using dynamic spilled array 11

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

    1. IFERROR VLOOKUP MAX value 8

      • ItsSugarBunny
    2. Replies
      8
      Views
      2.2k
      8
    3. AliGW

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

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

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

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

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

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

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

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

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

      • Chaffrin
    2. Replies
      3
      Views
      2.2k
      3
    3. royUK

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

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

Label

Display Options