Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • rehan kazi
    3. Replies
      16
      Views
      2.5k
      16

    4. rehan kazi

    2. lognormal graph 1

      • aeonstorm
    3. Replies
      1
      Views
      2.5k
      1

    4. jl2509

    2. growing range 7

      • Eusebious
    3. Replies
      7
      Views
      2.5k
      7

    4. Eusebious

    2. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    3. Replies
      12
      Views
      2.4k
      12

    4. B.W.B.

    2. Identify Row Number on Different Sheet to complete COUNTIF on (in single formula) 6

      • ruppk825
    3. Replies
      6
      Views
      2.4k
      6

    4. ruppk825

    2. Auto Fill Down Number List 11

      • luarbiasa
    3. Replies
      11
      Views
      2.4k
      11

    4. GIRISHBISHT

    2. Index/Match Formula Disappears after Ctrl-Shift-Enter 10

      • OldFella
    3. Replies
      10
      Views
      2.4k
      10

    4. OldFella

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

      • Range Rover
    3. Replies
      4
      Views
      2.4k
      4

    4. Range Rover

    2. Sum numbers in a single cell 7

      • chxjett
    3. Replies
      7
      Views
      2.3k
      7

    4. XOR LX

    2. Sumifs to sum qty's from 3 different columns with same criteria 19

      • Freddyfroo
    3. Replies
      19
      Views
      2.3k
      19

    4. KjBox

    2. Trying to generate actual selling day of current month and current year 6

      • dvswindler
    3. Replies
      6
      Views
      2.3k
      6

    4. FDibbins

    2. Copy data down and across range 24

      • jl2509
    3. Replies
      24
      Views
      2.3k
      24

    4. Carim

    2. Auto populating drop down lists/cells based on conditions 24

      • Boycie92
    3. Replies
      24
      Views
      2.3k
      24

    4. AliGW

    2. INCREMENT NUMERICAL STRING BY 1 17

      • Garth Lean
    3. Replies
      17
      Views
      2.3k
      17

    4. MandyRead

    2. Need help with  VLOOKUP by WEEKNUM 11

      • chobart46
    3. Replies
      11
      Views
      2.3k
      11

    4. Carim

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      2.3k
      21

    4. LearningXL

    2. TREND Function to Ignore Zeros 7

      • msquared99
    3. Replies
      7
      Views
      2.3k
      7

    4. Carim

    2. Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11

      • davex
    3. Replies
      11
      Views
      2.3k
      11

    4. KjBox

    2. Istext 3

    3. Replies
      3
      Views
      2.3k
      3

    4. cytop

    2. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    3. Replies
      3
      Views
      2.2k
      3

    4. AliGW

Label

Display Options