Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • brijeshkeni
    3. Replies
      13
      Views
      386
      13

    4. Carim

    2. Cell Value Fill Based on Color 11

      • dan_jordan84
    3. Replies
      11
      Views
      581
      11

    4. Carim

    2. CountIFS in same row problem 2

      • jbanks
    3. Replies
      2
      Views
      381
      2

    4. rory

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

      • paulbiddis
    3. Replies
      6
      Views
      501
      6

    4. rory

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

      • paulbiddis
    3. Replies
      19
      Views
      659
      19

    4. Carim

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

      • Smudge.Smith
    3. Replies
      7
      Views
      238
      7

    4. Carim

    2. EXCEL FORMULA 9

      • beealf
    3. Replies
      9
      Views
      545
      9

    4. Carim

    2. Nested IF ANDs 5

      • Sper434
    3. Replies
      5
      Views
      225
      5

    4. Carim

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

      • paulbiddis
    3. Replies
      10
      Views
      387
      10

    4. Carim

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

      • Retailmessiah
    3. Replies
      14
      Views
      710
      14

    4. Carim

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

      • jbanks
    3. Replies
      4
      Views
      248
      4

    4. Carim

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

      • jigarecity
    3. Replies
      4
      Views
      196
      4

    4. bosco_yip

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

      • jbanks
    3. Replies
      2
      Views
      153
      2

    4. jbanks

    2. Sum across worksheets while ignoring hidden worksheets 13

      • mike_calc
    3. Replies
      13
      Views
      473
      13

    4. Carim

    2. Need Help ASAP with this formula 3

      • overrated
    3. Replies
      3
      Views
      181
      3

    4. royUK

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

      • fi1808
    3. Replies
      5
      Views
      402
      5

    4. Carim

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

      • POQUACK
    3. Replies
      1
      Views
      121
      1

    4. royUK

    2. Auto-copy formating of cells 7

      • digitalricho
    3. Replies
      7
      Views
      428
      7

    4. Carim

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

      • ansh2792
    3. Replies
      3
      Views
      704
      3

    4. Carim

    2. INDEX MATCH of Two Lookup_Array 1

      • IEXCELMYWORK
    3. Replies
      1
      Views
      160
      1

    4. Carim

Display Options