Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. concatenate text and numbers 6

      • lolstre.loster
    3. Replies
      6
      Views
      1.5k
      6

    4. AliGW

    2. Sumproduct with blank criteria 7

      • DaneMark
    3. Replies
      7
      Views
      2.1k
      7

    4. XOR LX

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

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

    4. Emile du Toit

    2. Vlookup to subtract values across worksheets 9

      • RobertJ
    3. Replies
      9
      Views
      4.9k
      9

    4. AliGW

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

      • vbapadawan
    3. Replies
      2
      Views
      835
      2

    4. vbapadawan

    2. COUNTIF Problem 16

      • endl3ss
    3. Replies
      16
      Views
      2.2k
      16

    4. AliGW

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

      • t33p33
    3. Replies
      6
      Views
      1.7k
      6

    4. cytop

    2. percentage difference and if error leave blank 3

      • Gemma86
    3. Replies
      3
      Views
      878
      3

    4. AliGW

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

      • jamesharwood
    3. Replies
      7
      Views
      1.2k
      7

    4. sktneer

    2. SUMIF Totals based on multiple critertia 7

      • amanda0210
    3. Replies
      7
      Views
      1.2k
      7

    4. amanda0210

    2. Conditional Formatting Formula 2

      • brandybartz
    3. Replies
      2
      Views
      710
      2

    4. sktneer

    2. SUMIF Using Dynamic Ranges based on text similarities 5

      • endl3ss
    3. Replies
      5
      Views
      1.2k
      5

    4. NBVC

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

      • QAM
      • QAM
    3. Replies
      6
      Views
      1.5k
      6

    4. QAM

    2. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    3. Replies
      2
      Views
      1.5k
      2

    4. MathemAddicts

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

      • Daidin
    3. Replies
      2
      Views
      872
      2

    4. sktneer

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

      • ivorykeys87
    3. Replies
      2
      Views
      735
      2

    4. AliGW

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

      • johnreid7477
    3. Replies
      3
      Views
      1.1k
      3

    4. AliGW

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

      • merz
      • merz
    3. Replies
      1
      Views
      872
      1

    4. merz

    2. Convert Decimal To Text in Fraction format 1

      • JohnDrew
    3. Replies
      1
      Views
      852
      1

    4. rory

    2. Formulas using the "IF" function. 6

      • Pauli57
    3. Replies
      6
      Views
      1.4k
      6

    4. Pauli57

Label

Display Options