Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

    1. Drop down boxes and Pivot Tables 1

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

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

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

    1. Multiple sets of data in single cell 5

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

    1. Array Formula Value Error 7

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

    1. Modifying a formula 2

      • ajrilo1
    2. Replies
      2
      Views
      199
      2
    3. ajrilo1

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

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

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

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

    1. Cell Value Fill Based on Color 11

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

    1. CountIFS in same row problem 2

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

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

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

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

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

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

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

    1. EXCEL FORMULA 9

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

    1. Nested IF ANDs 5

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

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

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

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

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

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

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

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

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

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

      • jbanks
    2. Replies
      2
      Views
      172
      2
    3. jbanks

Display Options