Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Determine if "Active" if hire and term date are within cells range 2

      • Delta729
    3. Replies
      2
      Views
      1.6k
      2

    4. Delta729

    2. Indirect/substitute formula help 13

      • freddie0
    3. Replies
      13
      Views
      1.6k
      13

    4. GlennUK

    2. countifs with specific name between two dates 18

      • hahsj
    3. Replies
      18
      Views
      1.6k
      18

    4. MandyRead

    2. Custom searchable drop down list..... 8

      • nmkhan3010
    3. Replies
      8
      Views
      1.5k
      8

    4. GlennUK

    2. Revised vba to fill blanks in a range 19

      • kumarsatish
    3. Replies
      19
      Views
      1.5k
      19

    4. Carim

    2. if isnumber search and iserror vlookup index match - used together. 2

      • Emile du Toit
    3. Replies
      2
      Views
      1.5k
      2

    4. Emile du Toit

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

      • blade671
    3. Replies
      10
      Views
      1.5k
      10

    4. blade671

    2. Using a value from a cell inside a formula 8

      • yogeshtalks
    3. Replies
      8
      Views
      1.5k
      8

    4. NBVC

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

      • sathishsusa
    3. Replies
      15
      Views
      1.5k
      15

    4. Joris Moerings

    2. IF forumla to check if a value falls between two numbers 1

      • GG88
    3. Replies
      1
      Views
      1.5k
      1

    4. NBVC

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

      • OldFella
    3. Replies
      10
      Views
      1.5k
      10

    4. OldFella

    2. If cell is not empty, copy row... 9

      • micvoo
    3. Replies
      9
      Views
      1.5k
      9

    4. micvoo

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

      • davex
    3. Replies
      11
      Views
      1.5k
      11

    4. KjBox

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

      • Freddyfroo
    3. Replies
      19
      Views
      1.4k
      19

    4. KjBox

    2. xlookup multiple criteria? 2

      • browncoat
    3. Replies
      2
      Views
      1.4k
      2

    4. gyankosh.net

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

      • Boycie92
    3. Replies
      24
      Views
      1.4k
      24

    4. AliGW

    2. Hide duplicate running total values. 11

      • Skylane60
    3. Replies
      11
      Views
      1.4k
      11

    4. Skylane60

    2. Blank cells replace zeros 30

      • CJamesUK
    3. Replies
      30
      Views
      1.4k
      30

    4. royUK

    2. Find the max value if the value is not struck through 5

      • hmsiegel
    3. Replies
      5
      Views
      1.4k
      5

    4. skywriter

    2. Nested IF Statement Alternative 8

      • aussiformula
    3. Replies
      8
      Views
      1.4k
      8

    4. aussiformula

Display Options