| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Averaging the last 5 entries in a row
I have 20 numbers in a row (G34:Z34) I would like to average the last 5
entries. So if I have 10 entries (G34:P34),I would only like to average (L34:P34) Which is the last 5 entered and continue on averaging the last 5 all the way to (Z34). -- Geo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 part question on averaging | Excel Discussion (Misc queries) | |||
| counting non occur entries | Excel Discussion (Misc queries) | |||
| How do I take data entries and assign them to specific cells that. | Excel Discussion (Misc queries) | |||
| Automatic changes in cell entries | Excel Discussion (Misc queries) | |||
| Multiple Files, Duplicate Entries | Excel Discussion (Misc queries) | |||
Threaded Mode
