Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Highlight largest value cell in range based on other columns 15

      • paul789
    3. Replies
      15
      Views
      2.1k
      15

    4. AliGW

    2. SUMIF or SUMIFS 4

      • paul789
    3. Replies
      4
      Views
      880
      4

    4. alansidman

    2. Reg change of formula 8

      • Sholtan
    3. Replies
      8
      Views
      866
      8

    4. Sholtan

    2. Lookup a value 3

      • bogey69
    3. Replies
      3
      Views
      543
      3

    4. bogey69

    2. Making an indirect countifs formula dynamic 3

      • Helz_Belz
    3. Replies
      3
      Views
      697
      3

    4. AliGW

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

      • Crouty
    3. Replies
      5
      Views
      562
      5

    4. NBVC

    2. Roundup and IF Formula 1

      • jacjas
    3. Replies
      1
      Views
      475
      1

    4. NBVC

    2. define range (C1:C24) with formula 14

      • andrej
    3. Replies
      14
      Views
      1.9k
      14

    4. AliGW

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

      • Gemma86
    3. Replies
      3
      Views
      651
      3

    4. NBVC

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

      • Gemma86
    3. Replies
      1
      Views
      451
      1

    4. NBVC

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

      • woodstock1984
    3. Replies
      1
      Views
      503
      1

    4. NBVC

    2. Concatenate formula did not return expected value 2

      • mekrog
    3. Replies
      2
      Views
      561
      2

    4. mekrog

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

      • woodstock1984
    3. Replies
      2
      Views
      431
      2

    4. woodstock1984

    2. SUM with letters 1

      • crackwood01
    3. Replies
      1
      Views
      584
      1

    4. azumi

    2. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    3. Replies
      3
      Views
      2.2k
      3

    4. AliGW

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

      • Wobzy
    3. Replies
      3
      Views
      644
      3

    4. AliGW

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

      • avb85
    3. Replies
      3
      Views
      600
      3

    4. Carim

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

      • mystie
    3. Replies
      2
      Views
      558
      2

    4. mystie

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

      • cm882653
    3. Replies
      2
      Views
      450
      2

    4. cm882653

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

      • Dougmeister
    3. Replies
      1
      Views
      833
      1

    4. NBVC

Label

Display Options