Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. countifs with specific name between two dates 18

      • hahsj
    3. Replies
      18
      Views
      2.7k
      18

    4. MandyRead

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

      • rehan kazi
    3. Replies
      16
      Views
      2.6k
      16

    4. rehan kazi

    2. lognormal graph 1

      • aeonstorm
    3. Replies
      1
      Views
      2.6k
      1

    4. jl2509

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

      • OldFella
    3. Replies
      10
      Views
      2.6k
      10

    4. OldFella

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

      • Range Rover
    3. Replies
      4
      Views
      2.6k
      4

    4. Range Rover

    2. Need help with  VLOOKUP by WEEKNUM 11

      • chobart46
    3. Replies
      11
      Views
      2.6k
      11

    4. Carim

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

      • Boycie92
    3. Replies
      24
      Views
      2.6k
      24

    4. AliGW

    2. TREND Function to Ignore Zeros 7

      • msquared99
    3. Replies
      7
      Views
      2.5k
      7

    4. Carim

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

      • ruppk825
    3. Replies
      6
      Views
      2.5k
      6

    4. ruppk825

    2. growing range 7

      • Eusebious
    3. Replies
      7
      Views
      2.5k
      7

    4. Eusebious

    2. Combine Large and Sumif - Array formula 4

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

    4. London.London

    2. INDEX MATCH with multiple lookup_arrays/references 12

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

    4. B.W.B.

    2. Auto Fill Down Number List 11

      • luarbiasa
    3. Replies
      11
      Views
      2.5k
      11

    4. GIRISHBISHT

    2. Copy data down and across range 24

      • jl2509
    3. Replies
      24
      Views
      2.5k
      24

    4. Carim

    2. Searchable Dropdown List is working as a normal dropdown list in protected worksheet 8

      • MudasGrid
    3. Replies
      8
      Views
      2.4k
      8

    4. BlingGirl

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

      • dvswindler
    3. Replies
      6
      Views
      2.4k
      6

    4. FDibbins

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

      • Freddyfroo
    3. Replies
      19
      Views
      2.4k
      19

    4. KjBox

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

      • davex
    3. Replies
      11
      Views
      2.4k
      11

    4. KjBox

    2. Dynamic way to calculate the last 6 months average. 2

      • FaKest
    3. Replies
      2
      Views
      2.4k
      2

    4. royUK

    2. Sum numbers in a single cell 7

      • chxjett
    3. Replies
      7
      Views
      2.4k
      7

    4. XOR LX

Label

Display Options