Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • Delta729
    2. Replies
      2
      Views
      1.6k
      2
    3. Delta729

    1. Indirect/substitute formula help 13

      • freddie0
    2. Replies
      13
      Views
      1.6k
      13
    3. GlennUK

    1. countifs with specific name between two dates 18

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

    1. Custom searchable drop down list..... 8

      • nmkhan3010
    2. Replies
      8
      Views
      1.5k
      8
    3. GlennUK

    1. Revised vba to fill blanks in a range 19

      • kumarsatish
    2. Replies
      19
      Views
      1.5k
      19
    3. Carim

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

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

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

      • blade671
    2. Replies
      10
      Views
      1.5k
      10
    3. blade671

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

      • yogeshtalks
    2. Replies
      8
      Views
      1.5k
      8
    3. NBVC

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

      • sathishsusa
    2. Replies
      15
      Views
      1.5k
      15
    3. Joris Moerings

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

      • GG88
    2. Replies
      1
      Views
      1.5k
      1
    3. NBVC

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

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

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

      • micvoo
    2. Replies
      9
      Views
      1.5k
      9
    3. micvoo

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

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

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

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

    1. xlookup multiple criteria? 2

      • browncoat
    2. Replies
      2
      Views
      1.4k
      2
    3. gyankosh.net

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

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

    1. Hide duplicate running total values. 11

      • Skylane60
    2. Replies
      11
      Views
      1.4k
      11
    3. Skylane60

    1. Blank cells replace zeros 30

      • CJamesUK
    2. Replies
      30
      Views
      1.4k
      30
    3. royUK

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

      • hmsiegel
    2. Replies
      5
      Views
      1.4k
      5
    3. skywriter

    1. Nested IF Statement Alternative 8

      • aussiformula
    2. Replies
      8
      Views
      1.4k
      8
    3. aussiformula

Display Options