Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Moving to a specific cell based on another cell's data. 2

      • VWRSue
    2. Replies
      2
      Views
      179
      2
    3. Carim

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

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

    1. Match and extract values on different columns 3

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

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

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

    1. Drop down boxes and Pivot Tables 1

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

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

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

    1. Multiple sets of data in single cell 5

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

    1. Array Formula Value Error 7

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

    1. Modifying a formula 2

      • ajrilo1
    2. Replies
      2
      Views
      202
      2
    3. ajrilo1

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

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

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

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

    1. Cell Value Fill Based on Color 11

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

    1. CountIFS in same row problem 2

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

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

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

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

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

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

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

    1. EXCEL FORMULA 9

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

    1. Nested IF ANDs 5

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

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

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

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

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

Display Options