Forum Discussion
Sorting data with links
I have a list of data where some cells contains links to other cells withing the data. When I try to sort it the rows the data is moved around but the row numbers keeps their numbers. This means that...
Hi Eric
I think you've just noticed it. As far as I know the references to cells haven't ever changed when those referenced cells are in a list that you then sort.
I think you've just noticed it. As far as I know the references to cells haven't ever changed when those referenced cells are in a list that you then sort.
My $0.02
In more general, the reference is a formula. Sorting the range with formulas is equivalent of moving such formulas from one cell to another. If in C10 is the reference or any other formula with reference on B10, we may copy B10:C10 and paste it into B5:C5 - effect will be the same as after the sorting of B5:C10 if value from B10 appears on B5 place.
For my knowledge there is nothing new in such behaviour, it's the same for years if not for entire history.