Via '=', I want to link one cell (eg B10) to another cell (say D15), but when I 'Sort' the column containing D15 and it moves to say D18, I want the link to stay with the original cell, i.e., D18 not stay on D15.
Via '=', I want to link one cell (eg B10) to another cell (say D15), but when I 'Sort' the column containing D15 and it moves to say D18, I want the link to stay with the original cell, i.e., D18 not stay on D15.
Use absolute addressing, i.e.:
=$D$15
Hope this helps.
Pete
To keep referring to a cell that changes coordinates, you need to find something else about that cell that stays unique.
I suppose the content of the cell changes from time to time (else there wouldn't be much sence in referring to it), so see if it has a unique cell next to it (that is sorted along with the other cell). So if this D15 has a cell next to it (E15) with a unique value, just use something like a LOOKUP formula to find D15 via E15 (or D18 via E18 when sorted).
Last edited by L-Drr; 08-14-2013 at 05:52 AM.
When I say semicolon, u say comma!
Thanks for the reply Pete.
But $D$15 just cements D15 as the cell location. I want to have the link to the original number in D15 and stay linked as it moves to a new location.
Trumby
Last edited by trumby; 08-14-2013 at 03:32 PM.
Thanks L-Drr,
But I'm looking for something a bit simpler and which will work with many links. The example I gave was for one link but I want this to work with hundreds of links.
Cheers
Trumby
I don't know if there is an easy way for this...
Maybe it is possible to write an array formula (or something like that) to use instead of the sorting option? Anybody with array knowledge who knows if this can be done?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks