| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sort data without formulas in other cells changing?
Hi,
Can someone please help? I've got quite a lot of data that I want to sort by the persons date of birth, but because I have cells with formula in it (this works out the persons age) the sort function is changing the formulas so the formulas no longer work becuase it changes the cell where it is getting the data from. Does anyone have any ideas how this could be fixed?? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort merged cells | Excel Worksheet Functions | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
| extract data from cells | Excel Worksheet Functions | |||
Threaded Mode
