Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Conditional Formatting with Date/Time 4

      • jnepsa
    2. Replies
      4
      Views
      813
      4
    3. jnepsa

    1. vlookup to count based on criteria? 6

      • Gemma86
    2. Replies
      6
      Views
      1.2k
      6
    3. Gemma86

    1. AverageIf #DIV/0! error 10

      • Murph0625
    2. Replies
      10
      Views
      3.6k
      10
    3. NBVC

    1. Minimum Date if cell contains part of another cell value 10

      • dRaz
      • dRaz
    2. Replies
      10
      Views
      1.7k
      10
    3. AliGW

    1. Removing Characters out of a long string of characters via formula 5

      • DaveSharpe79
    2. Replies
      5
      Views
      781
      5
    3. pike

    1. Copy formula from Row above if Cell Value changes. 5

      • JohnDrew
    2. Replies
      5
      Views
      1.1k
      5
    3. JohnDrew

    1. Convert Time into Hours in Excel 1

      • DaveSharpe79
    2. Replies
      1
      Views
      478
      1
    3. Flyboy65

    1. Return "YES" if cell H2 >12 and cell P2=Open - If no match return "NO" 5

      • MantaLady
    2. Replies
      5
      Views
      785
      5
    3. AliGW

    1. Formula that that leaves cell blank if 2 cells meet logical parameters 3

      • skeeeter
    2. Replies
      3
      Views
      632
      3
    3. pike

    1. Allocate a value over multiple years based on a specified date range 1

      • jask
      • jask
    2. Replies
      1
      Views
      749
      1
    3. alansidman

    1. Formula to count times a specific number will divide into another + rounding rules 1

      • j6bennett1
    2. Replies
      1
      Views
      475
      1
    3. pike

    1. Formula to return which quartile a given number falls in 3

      • CCA BSM
    2. Replies
      3
      Views
      7.5k
      3
    3. S O

    1. Map text to numeric rankings 2

      • clariinc
    2. Replies
      2
      Views
      758
      2
    3. clariinc

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

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

    1. Time calculation inconsistent 1

      • Gyster
    2. Replies
      1
      Views
      538
      1
    3. Gyster

    1. Power Forecast Formula Errors Out on Legitimate Value 3

      • JamesRyann
    2. Replies
      3
      Views
      817
      3
    3. JamesRyann

    1. Find solution to #VALUE! error message in SUMPRODUCT 4

      • bellevue
    2. Replies
      4
      Views
      792
      4
    3. NBVC

    1. Average & standard deviation of hh:mm:ss 1

      • R. Saran
    2. Replies
      1
      Views
      725
      1
    3. Krishnakumar

    1. SUMIF using Variable Columns 4

      • sajo
    2. Replies
      4
      Views
      1.2k
      4
    3. sajo

    1. Formula to look at dates and bring back value 1

      • excellquestion
    2. Replies
      1
      Views
      480
      1
    3. NBVC

Label

Display Options