Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Find a value in a row and column, return intersecting cell value 6

      • t33p33
    2. Replies
      6
      Views
      1.5k
      6
    3. cytop

    1. percentage difference and if error leave blank 3

      • Gemma86
    2. Replies
      3
      Views
      796
      3
    3. AliGW

    1. Sum of all values to the right of a selected value in a table. 7

      • jamesharwood
    2. Replies
      7
      Views
      1.1k
      7
    3. sktneer

    1. SUMIF Totals based on multiple critertia 7

      • amanda0210
    2. Replies
      7
      Views
      1.1k
      7
    3. amanda0210

    1. Conditional Formatting Formula 2

      • brandybartz
    2. Replies
      2
      Views
      649
      2
    3. sktneer

    1. SUMIF Using Dynamic Ranges based on text similarities 5

      • endl3ss
    2. Replies
      5
      Views
      1.1k
      5
    3. NBVC

    1. Count of unique name and date of birth matches 6

      • QAM
      • QAM
    2. Replies
      6
      Views
      1.3k
      6
    3. QAM

    1. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    2. Replies
      2
      Views
      1.3k
      2
    3. MathemAddicts

    1. move cell values in Description from colums onto the same row based on a key 2

      • Daidin
    2. Replies
      2
      Views
      793
      2
    3. sktneer

    1. Tips on getting around length limits for formulas? 2

      • ivorykeys87
    2. Replies
      2
      Views
      667
      2
    3. AliGW

    1. Auto Number +1 from text, if duplicate text not increase 3

      • johnreid7477
    2. Replies
      3
      Views
      936
      3
    3. AliGW

    1. Use Hlookup to find then sum column within specific dates 1

      • merz
      • merz
    2. Replies
      1
      Views
      804
      1
    3. merz

    1. Convert Decimal To Text in Fraction format 1

      • JohnDrew
    2. Replies
      1
      Views
      782
      1
    3. rory

    1. Formulas using the "IF" function. 6

      • Pauli57
    2. Replies
      6
      Views
      1.3k
      6
    3. Pauli57

    1. Counting the frequency of a specific number on a specific day 2

      • M Edwards
    2. Replies
      2
      Views
      742
      2
    3. M Edwards

    1. Contiguous Weighted Average Excluding Zeroes 2

      • gc052
    2. Replies
      2
      Views
      806
      2
    3. gc052

    1. An array excel formula to increase the numebrs in the array bracket 3

      • sarah81
    2. Replies
      3
      Views
      791
      3
    3. NBVC

    1. Sum if with 2 conditions 1

      • eurano
    2. Replies
      1
      Views
      632
      1
    3. NBVC

    1. Excel formula err lookup 1

      • libin baby
    2. Replies
      1
      Views
      743
      1
    3. NBVC

    1. Sumproduct and mid function 1

      • eurano
    2. Replies
      1
      Views
      757
      1
    3. NBVC

Display Options