| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting screws up referencing
I have several columns of data and a separate cell that contains a formula
referring to a range within one of the columns, for example AVERAGE(A10:A100). Now I subject my data, including column A, to sorting, and the annoying result is that AVERAGE now refers to different data. Is there a way to avoid that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
| Is this a joke or Microsoft screws up again? | Excel Discussion (Misc queries) | |||
| Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
| My formula screws up other reference cells... | Excel Discussion (Misc queries) | |||
Threaded Mode
