Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Count number of zeros that are within a range of consecutive zeros 2

      • annasigler
    2. Replies
      2
      Views
      1.2k
      2
    3. richadj4

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

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

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

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

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

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

    1. Return text from colomn if meets criteria in another colomn 1

      • SBRIGHT
    2. Replies
      1
      Views
      458
      1
    3. NBVC

    1. Extract Value from a Text String 1

      • beewketu
    2. Replies
      1
      Views
      470
      1
    3. beewketu

    1. How to count consecutive numbers based on the first number of the column 4

      • Mathman1
    2. Replies
      4
      Views
      1.3k
      4
    3. Stanley D. Grom

    1. Complex IF (AND (OR formula 8

      • missjoy
    2. Replies
      8
      Views
      1.3k
      8
    3. KjBox

    1. Run time error 13 Type mismatch in VBA 1

      • analystbank
    2. Replies
      1
      Views
      571
      1
    3. analystbank

    1. Formula to show which Staff have had no sick leave for previous 3 months 6

      • skeeeter
    2. Replies
      6
      Views
      854
      6
    3. AliGW

    1. Formula looking at 3 values 5

      • enhydra
    2. Replies
      5
      Views
      666
      5
    3. KjBox

    1. Conditional Format Formula Help 1

      • gliffix101
    2. Replies
      1
      Views
      501
      1
    3. Infomage

    1. Calculating the total commission value from a sliding scale 10

      • 3008300363
    2. Replies
      10
      Views
      1.3k
      10
    3. KjBox

    1. Count cells based on different criteria? 1

      • hkaur08
    2. Replies
      1
      Views
      498
      1
    3. Ger Plante

    1. Subtracting time depending on text in a previous cell 13

      • CaulfieldS
    2. Replies
      13
      Views
      1.3k
      13
    3. AliGW

    1. Trying to retrieve Data over multiple Rows and Columns 3

      • Trompie2017
    2. Replies
      3
      Views
      722
      3
    3. CaulfieldS

    1. Drop Down Menu with Two Possible Prefilled Scenarios 1

      • actinogen
    2. Replies
      1
      Views
      673
      1
    3. actinogen

    1. Associating a date with specific group of numbers 2

      • rsaha
    2. Replies
      2
      Views
      638
      2
    3. rsaha

    1. Delete Entry with 0 and entry beside it 5

      • JDmacromanZ
    2. Replies
      5
      Views
      1.2k
      5
    3. KjBox

    1. Fill Cell with Colour 1

      • prayaboutit2
    2. Replies
      1
      Views
      573
      1
    3. Logit

Display Options