| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas changing when sorting
I have a simple spreadsheet, and would like to be able to sort on any
field... sounds simple - you'd think so, but when l do it two columns lose the plot. Both of these columns are referring to a static field, field A29 (todays date) - however when l sort the spreadsheet - these columns lose the plot and the formulas change in each row to A28 A27, A26 etc. I want all rows to keep pointing to field A29 - what is going on? I have been using excel for years and never ever seen this before. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas changing when sorting
use absolute references
=$A$29 Mike "harleyq" wrote: I have a simple spreadsheet, and would like to be able to sort on any field... sounds simple - you'd think so, but when l do it two columns lose the plot. Both of these columns are referring to a static field, field A29 (todays date) - however when l sort the spreadsheet - these columns lose the plot and the formulas change in each row to A28 A27, A26 etc. I want all rows to keep pointing to field A29 - what is going on? I have been using excel for years and never ever seen this before. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Right to Left sorting without changing language settings | Excel Discussion (Misc queries) | |||
| Changing the sorting order... | Excel Worksheet Functions | |||
| sorting without changing formats | Excel Worksheet Functions | |||
| sorting rows without changing order of my values! | Excel Discussion (Misc queries) | |||
| sorting a constantly changing set of rows in VBA | Excel Discussion (Misc queries) | |||
Linear Mode
