Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • vbapadawan
    2. Replies
      2
      Views
      413
      2
    3. vbapadawan

    1. Need help with Vlookup not working 4

      • vba_monkey
    2. Replies
      4
      Views
      530
      4
    3. Carim

    1. Return the last number in a range that is not in a coloured cell 3

      • vanhunk
    2. Replies
      3
      Views
      467
      3
    3. vanhunk

    1. Lookup next largest with multiple equal values 2

      • URIE
      • URIE
    2. Replies
      2
      Views
      85
      2
    3. URIE

    1. Formula FIX 1

      • unstefan
    2. Replies
      1
      Views
      59
      1
    3. Carim

    1. How to calculate time duration from date & times in individual times? 7

      • unknown_brother
    2. Replies
      7
      Views
      213
      7
    3. Carim

    1. Copy/create new list if value in column is partial match with criteria

      • unknown_brother
    2. Replies
      0
      Views
      55
    1. Coveryting VB Macro form to Google sheet 1

      • umakanth79in
    2. Replies
      1
      Views
      240
      1
    3. royUK

    1. Countifs miscalculates date and time criteria 9

      • udhaya_k
    2. Replies
      9
      Views
      195
      9
    3. AliGW

    1. Getting #N/A error when the value exist (using False) 3

      • U_encore1
    2. Replies
      3
      Views
      76
      3
    3. Carim

    1. CountA .. If then Else Statement not working 3

      • tyneexi
    2. Replies
      3
      Views
      187
      3
    3. rabsofty

    1. if 2 cells in one row match 2 cells in another row copy a cell 4

      • Tylerh
    2. Replies
      4
      Views
      198
      4
    3. Tylerh

    1. Extracting a string up to a specific word (exact match) 3

      • Twiceborn
    2. Replies
      3
      Views
      90
      3
    3. Fluff13

    1. Reading new column data using same formula 9

      • tuffley21
    2. Replies
      9
      Views
      175
      9
    3. NBVC

    1. How to find Country Code and phone number mismatch? 1

      • Tsha M
    2. Replies
      1
      Views
      226
      1
    3. Oponion

    1. Trying to retrieve Data over multiple Rows and Columns 3

      • Trompie2017
    2. Replies
      3
      Views
      405
      3
    3. CaulfieldS

    1. Excel says: You've entered too many arguments for this function: 4

      • Trish123
    2. Replies
      4
      Views
      3k
      4
    3. AAE

    1. Adapting a linear annual calendar from data used to generate monthly annual calendars 3

      • Trev81
    2. Replies
      3
      Views
      331
      3
    3. Trev81

    1. using 2 multi conditional if then statements based on value of another cell 11

      • trader1588
    2. Replies
      11
      Views
      662
      11
    3. AliGW

    1. IF formula. 1

      • toniock7
    2. Replies
      1
      Views
      61
      1
    3. NBVC

Display Options