Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. countifs with specific name between two dates 18

      • hahsj
    2. Replies
      18
      Views
      2.6k
      18
    3. MandyRead

    1. lognormal graph 1

      • aeonstorm
    2. Replies
      1
      Views
      2.6k
      1
    3. jl2509

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

      • rehan kazi
    2. Replies
      16
      Views
      2.6k
      16
    3. rehan kazi

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

      • OldFella
    2. Replies
      10
      Views
      2.6k
      10
    3. OldFella

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

      • Range Rover
    2. Replies
      4
      Views
      2.5k
      4
    3. Range Rover

    1. growing range 7

      • Eusebious
    2. Replies
      7
      Views
      2.5k
      7
    3. Eusebious

    1. Need help with  VLOOKUP by WEEKNUM 11

      • chobart46
    2. Replies
      11
      Views
      2.5k
      11
    3. Carim

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

      • Boycie92
    2. Replies
      24
      Views
      2.5k
      24
    3. AliGW

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

      • ruppk825
    2. Replies
      6
      Views
      2.5k
      6
    3. ruppk825

    1. TREND Function to Ignore Zeros 7

      • msquared99
    2. Replies
      7
      Views
      2.5k
      7
    3. Carim

    1. INDEX MATCH with multiple lookup_arrays/references 12

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

    1. Auto Fill Down Number List 11

      • luarbiasa
    2. Replies
      11
      Views
      2.4k
      11
    3. GIRISHBISHT

    1. Copy data down and across range 24

      • jl2509
    2. Replies
      24
      Views
      2.4k
      24
    3. Carim

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

      • dvswindler
    2. Replies
      6
      Views
      2.4k
      6
    3. FDibbins

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

      • Freddyfroo
    2. Replies
      19
      Views
      2.4k
      19
    3. KjBox

    1. Sum numbers in a single cell 7

      • chxjett
    2. Replies
      7
      Views
      2.4k
      7
    3. XOR LX

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

      • davex
    2. Replies
      11
      Views
      2.4k
      11
    3. KjBox

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

      • MudasGrid
    2. Replies
      8
      Views
      2.4k
      8
    3. BlingGirl

    1. INCREMENT NUMERICAL STRING BY 1 17

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

    1. Worsheet_change Multiple uses same sheet 21

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

Label

Display Options