Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

    1. Cell Value Fill Based on Color 11

      • dan_jordan84
    2. Replies
      11
      Views
      581
      11
    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. FILTER and UNIQUE - dependent dropdown lists... 19

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

    1. Formula for calculating totals for different months in a list as a percentage? 7

      • Smudge.Smith
    2. Replies
      7
      Views
      238
      7
    3. Carim

    1. EXCEL FORMULA 9

      • beealf
    2. Replies
      9
      Views
      545
      9
    3. Carim

    1. Nested IF ANDs 5

      • Sper434
    2. Replies
      5
      Views
      225
      5
    3. Carim

    1. INDIRECT function does not work when referencing to a dynamic list 10

      • paulbiddis
    2. Replies
      10
      Views
      387
      10
    3. Carim

    1. Combining Monthly Fee Totals by month, year, and location with Annual Fee Increases 14

      • Retailmessiah
    2. Replies
      14
      Views
      710
      14
    3. Carim

    1. Count number of cells with more than 3 charactors 4

      • jbanks
    2. Replies
      4
      Views
      248
      4
    3. Carim

    1. data array with date range and return text value in result 4

      • jigarecity
    2. Replies
      4
      Views
      196
      4
    3. bosco_yip

    1. Sum of chosen cells based on searched criteria? Countifs? Sumif? SumProduct? 2

      • jbanks
    2. Replies
      2
      Views
      153
      2
    3. jbanks

    1. Sum across worksheets while ignoring hidden worksheets 13

      • mike_calc
    2. Replies
      13
      Views
      473
      13
    3. Carim

    1. Need Help ASAP with this formula 3

      • overrated
    2. Replies
      3
      Views
      181
      3
    3. royUK

    1. How to update a cell when new data is entered 5

      • fi1808
    2. Replies
      5
      Views
      402
      5
    3. Carim

    1. find a match using vlookup (but not just first entry) 1

      • POQUACK
    2. Replies
      1
      Views
      121
      1
    3. royUK

    1. Auto-copy formating of cells 7

      • digitalricho
    2. Replies
      7
      Views
      428
      7
    3. Carim

    1. Please help for create formula using Isnumber, search and vlookup or index. 3

      • ansh2792
    2. Replies
      3
      Views
      704
      3
    3. Carim

    1. INDEX MATCH of Two Lookup_Array 1

      • IEXCELMYWORK
    2. Replies
      1
      Views
      160
      1
    3. Carim

Display Options