| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I move data without changing an associated formula?
I have created an Excel worksheet which I update with new values each day
(golf scores). I keep the last 10 scores but want an average of the last 5 scores. How can I move the data one column to the left and not change the averaging formula so that when I post the new score it still uses the original formula (sum of G5 to K5 devided by 5). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I move data from workbook A to B using a conditional formula | Excel Worksheet Functions | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| how can I move cells after data input without using enter or tab | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| How to move data on worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
