Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Index Small function to skip blank rows 8

      • dloc_26
    2. Replies
      8
      Views
      4.8k
      8
    3. Roger1955

    1. Randomly choose one instance of a text from multiple occurrences in a list or column 5

      • Crouty
    2. Replies
      5
      Views
      562
      5
    3. NBVC

    1. Roundup and IF Formula 1

      • jacjas
    2. Replies
      1
      Views
      475
      1
    3. NBVC

    1. If date and time formatted cell is 2 hours after different date and time formatted 3

      • Gemma86
    2. Replies
      3
      Views
      651
      3
    3. NBVC

    1. if and multiple criteria and if cell doesnt not contain specfic word 1

      • Gemma86
    2. Replies
      1
      Views
      451
      1
    3. NBVC

    1. Copy row of data if column 1 is a certain number 1

      • woodstock1984
    2. Replies
      1
      Views
      503
      1
    3. NBVC

    1. Concatenate formula did not return expected value 2

      • mekrog
    2. Replies
      2
      Views
      561
      2
    3. mekrog

    1. Show a particular letter/value if a specific cell is included with one of the lists 2

      • woodstock1984
    2. Replies
      2
      Views
      431
      2
    3. woodstock1984

    1. SUM with letters 1

      • crackwood01
    2. Replies
      1
      Views
      584
      1
    3. azumi

    1. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    2. Replies
      3
      Views
      2.2k
      3
    3. AliGW

    1. Making an indirect countifs formula dynamic 3

      • Helz_Belz
    2. Replies
      3
      Views
      697
      3
    3. AliGW

    1. COUNTIFS or SUMPRODUCT? Match criteria if other criteria is met. 3

      • Wobzy
    2. Replies
      3
      Views
      644
      3
    3. AliGW

    1. Find a sum based on a date range and an aditional value 3

      • avb85
    2. Replies
      3
      Views
      600
      3
    3. Carim

    1. Filling a column with text values extracted from another sheet 2

      • mystie
    2. Replies
      2
      Views
      558
      2
    3. mystie

    1. WEEKDAYNAME function not working... error #NAME? (Excel 2013) 1

      • Dougmeister
    2. Replies
      1
      Views
      833
      1
    3. NBVC

    1. Formula/VLOOKUP for multiple 'greater than' criteria to return multiple results 2

      • cm882653
    2. Replies
      2
      Views
      451
      2
    3. cm882653

    1. "tilde" in vlookup formula 13

      • Anri
      • Anri
    2. Replies
      13
      Views
      3.4k
      13
    3. Carim

    1. Date wise sum of value 7

      • makhdoomliaqat
    2. Replies
      7
      Views
      1.2k
      7
    3. Carim

    1. IF AND OR statement 4

      • 3ball
    2. Replies
      4
      Views
      712
      4
    3. Trebor76

    1. Formula for adding previous sheets 2

      • jberena
    2. Replies
      2
      Views
      461
      2
    3. royUK

Label

Display Options