Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Vlookup to subtract values across worksheets 9

      • RobertJ
    2. Replies
      9
      Views
      5k
      9
    3. AliGW

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

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

    1. Sum the values in one column only unique vauels from another 2

      • vbapadawan
    2. Replies
      2
      Views
      842
      2
    3. vbapadawan

    1. COUNTIF Problem 16

      • endl3ss
    2. Replies
      16
      Views
      2.2k
      16
    3. AliGW

    1. percentage difference and if error leave blank 3

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

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

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

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

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

    1. Sumproduct with blank criteria 7

      • DaneMark
    2. Replies
      7
      Views
      2.1k
      7
    3. XOR LX

    1. Conditional Formatting Formula 2

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

    1. SUMIF Using Dynamic Ranges based on text similarities 5

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

    1. SUMIF Totals based on multiple critertia 7

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

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

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

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

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

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

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

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

      • johnreid7477
    2. Replies
      3
      Views
      1.1k
      3
    3. AliGW

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

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

    1. Convert Decimal To Text in Fraction format 1

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

    1. Comparing VLOOKUP speeds versus straight calculations 2

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

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

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

    1. Contiguous Weighted Average Excluding Zeroes 2

      • gc052
    2. Replies
      2
      Views
      894
      2
    3. gc052

Label

Display Options