Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • paul789
    2. Replies
      15
      Views
      2.1k
      15
    3. AliGW

    1. SUMIF or SUMIFS 4

      • paul789
    2. Replies
      4
      Views
      880
      4
    3. alansidman

    1. Reg change of formula 8

      • Sholtan
    2. Replies
      8
      Views
      866
      8
    3. Sholtan

    1. Lookup a value 3

      • bogey69
    2. Replies
      3
      Views
      543
      3
    3. bogey69

    1. Making an indirect countifs formula dynamic 3

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

    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. define range (C1:C24) with formula 14

      • andrej
    2. Replies
      14
      Views
      1.9k
      14
    3. AliGW

    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. 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. Formula/VLOOKUP for multiple 'greater than' criteria to return multiple results 2

      • cm882653
    2. Replies
      2
      Views
      450
      2
    3. cm882653

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

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

Label

Display Options