| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up / match / reference cell
Hi
Am wanting to determine a 3 month average based on the 3 months proceeding the current month. The spreadsheet contains 12 months of data. If the current month is determined elsewhere in the data on the spreadsheet, how can I use that so that I can determine the 3 month average for the months preceeding the current month. Eg Current month = May jan feb mar apr may june july aug sep oct nov dec last 3 month avg 5 7 10 6 9 ?? (based on feb mar apr) When June comes around the 3 month average should then move to be based on Mar, Apr & May. Any thoughts?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX - MATCH - VLOOKUP - returning missing reference | Excel Discussion (Misc queries) | |||
| Find the closest match to a reference number in a row of unsorted | Excel Worksheet Functions | |||
| How can I make the reference link match the new formatting of its | Excel Discussion (Misc queries) | |||
| match data to reference then vlookup | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Threaded Mode
