Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. FILTER and UNIQUE - dependent dropdown lists... 19

      • paulbiddis
    2. Replies
      19
      Views
      659
      19
    3. Carim

    1. CountIFS in same row problem 2

      • jbanks
    2. Replies
      2
      Views
      381
      2
    3. rory

    1. 'tricking' excel to recognise a table header outside of the table 6

      • paulbiddis
    2. Replies
      6
      Views
      501
      6
    3. rory

    1. Cell Value Fill Based on Color 11

      • dan_jordan84
    2. Replies
      11
      Views
      581
      11
    3. Carim

    1. Extract text from a string of text based on the range defined 13

      • brijeshkeni
    2. Replies
      13
      Views
      386
      13
    3. Carim

    1. Match one cell value with another then extract row data 3

      • Smudge.Smith
    2. Replies
      3
      Views
      162
      3
    3. Carim

    1. Modifying a formula 2

      • ajrilo1
    2. Replies
      2
      Views
      182
      2
    3. ajrilo1

    1. Array Formula Value Error 7

      • Excel Noob
    2. Replies
      7
      Views
      306
      7
    3. Carim

    1. Multiple sets of data in single cell 5

      • ajrilo1
    2. Replies
      5
      Views
      233
      5
    3. royUK

    1. Calculate ONLY if before the 10th day of month 7

      • Mirinjawbro
    2. Replies
      7
      Views
      252
      7
    3. Mirinjawbro

    1. Drop down boxes and Pivot Tables 1

      • kramer100
    2. Replies
      1
      Views
      136
      1
    3. royUK

    1. Match and extract values on different columns 3

      • glenhmalefe2ds
    2. Replies
      3
      Views
      256
      3
    3. S O

    1. Display data from one tab as merged cells on another tab of workbook 12

      • ajrilo1
    2. Replies
      12
      Views
      577
      12
    3. ajrilo1

    1. Creating dynamic sheet reference while retaining "cell progression", for lack of the correct term ;-) 5

      • DerNuB
    2. Replies
      5
      Views
      185
      5
    3. Carim

    1. Formula not working when Worksheet is Protected 2

      • mrbuttons
    2. Replies
      2
      Views
      150
      2
    3. mrbuttons

    1. Conditional Format Exact Match 3

      • Sper434
    2. Replies
      3
      Views
      187
      3
    3. Carim

    1. write formula in work sheet 7

      • supriyamk
    2. Replies
      7
      Views
      264
      7
    3. Carim

    1. excel formula to lookup year and sum 3

      • dkool
    2. Replies
      3
      Views
      170
      3
    3. Carim

    1. Returning the last row of text in a cell, minus the first few words 4

      • chad71
    2. Replies
      4
      Views
      220
      4
    3. Carim

    1. Clear cell range without using VBA/Macro 4

      • kmsafstrom
    2. Replies
      4
      Views
      244
      4
    3. Carim

Display Options