Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. INCREMENT NUMERICAL STRING BY 1 17

      • Garth Lean
    3. Replies
      17
      Views
      2.4k
      17

    4. MandyRead

    2. Auto Add/Subtract 10

      • JJeffery99
    3. Replies
      10
      Views
      2.4k
      10

    4. yongle

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      2.3k
      21

    4. LearningXL

    2. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    3. Replies
      3
      Views
      2.3k
      3

    4. AliGW

    2. Excel Formula Sum of Minimum Values 10

      • GIRISHBISHT
    3. Replies
      10
      Views
      2.3k
      10

    4. pike

    2. Istext 3

    3. Replies
      3
      Views
      2.3k
      3

    4. cytop

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

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

    4. Carim

    2. Highlight if Cell contains asterisk(*) 8

      • Anna Mary
    3. Replies
      8
      Views
      2.3k
      8

    4. alansidman

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

      • MexicoGuy
    3. Replies
      6
      Views
      2.3k
      6

    4. FDibbins

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

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

    4. Rovi

    2. COUNTIF Problem 16

      • endl3ss
    3. Replies
      16
      Views
      2.3k
      16

    4. AliGW

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

      • tac_79
    3. Replies
      5
      Views
      2.3k
      5

    4. tac_79

    2. YTD using dynamic spilled array 11

      • MatthewHart
    3. Replies
      11
      Views
      2.2k
      11

    4. AliGW

    2. IFERROR VLOOKUP MAX value 8

      • ItsSugarBunny
    3. Replies
      8
      Views
      2.2k
      8

    4. AliGW

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

      • sathishsusa
    3. Replies
      15
      Views
      2.2k
      15

    4. Joris Moerings

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

      • shinobi09
    3. Replies
      6
      Views
      2.2k
      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.2k
      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.2k
      10

    4. blade671

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

      • Chaffrin
    3. Replies
      3
      Views
      2.2k
      3

    4. royUK

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

      • paul789
    3. Replies
      15
      Views
      2.2k
      15

    4. AliGW

Label

Display Options