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! |
#2
|
|||
|
|||
I bet you have formulas that point directly at other cells in another worksheet:
=sheet2!b3 If you do, you may want to see if you can redesign your worksheet so that you can use some key column (name/id???) that can be used to bring back the birthdate. Depending on how that table is set up, you may be able to use =vlookup() or =index(match()). Debra Dalgleish has some nice instructions for =vlookup() at: http://www.contextures.com/xlFunctions02.html and you didn't ask, but she has some nice instructions for =index(match()) at: http://www.contextures.com/xlFunctions03.html Vicky wrote: 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! -- Dave Peterson |
#3
|
|||
|
|||
Vicky
either your formula are absolute eg $a$1 (must take off before sorting) or you are not sorting all data including formula please give example of layout if this doesnot help Tina "Vicky" wrote: 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! |
Reply |
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 |