Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

    1. Roundup and IF Formula 1

      • jacjas
    2. Replies
      1
      Views
      476
      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
      658
      3
    3. NBVC

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

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

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

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

    1. Concatenate formula did not return expected value 2

      • mekrog
    2. Replies
      2
      Views
      573
      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
      436
      2
    3. woodstock1984

    1. SUM with letters 1

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

    1. Use COUNTIF on column that contains TRIM formula 3

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

    1. Making an indirect countifs formula dynamic 3

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

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

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

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

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

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

      • mystie
    2. Replies
      2
      Views
      575
      2
    3. mystie

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

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

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

      • cm882653
    2. Replies
      2
      Views
      457
      2
    3. cm882653

    1. "tilde" in vlookup formula 13

      • Anri
      • Anri
    2. Replies
      13
      Views
      3.5k
      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
      736
      4
    3. Trebor76

    1. Formula for adding previous sheets 2

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

    1. Transfering data 3

      • kennethbrandon
    2. Replies
      3
      Views
      891
      3
    3. alansidman

Label

Display Options