| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Averages
Hello, I need to design a spreadsheet that averages the last 5 and last 10
numbers in a row of up to 40 numbers. There will be various random spaces between the entered numbers. So for example, if there are 15 numbers spread over 40 rows, I would need to average the last 5 which could each have a few spaces between them. There will be no 0's or negatives in the data. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Formula for Yearly Averages | Excel Discussion (Misc queries) | |||
| Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
| averages | Excel Worksheet Functions | |||
| Help with averages please | Excel Worksheet Functions | |||
| Min & Max Averages | Excel Worksheet Functions | |||
Threaded Mode
