Real-time sorting
Thanks to all who replied.
LARGE is the right function for the job. Works like a charm, but (there's
always a but) what if I want to anchor the sorting of A1:A5 to a neighboring
column, say B1:B5, that hold the labels for the values in A1:A5 ?
In other words, I want B1:B5 to "follow" the real-time sorting of A1:A2. Can
it be done?
I played with Mathematical/Statistical/String functions for a few hours but
couldn't figure out how to create a relation between the two columns (A and
B) so that when LARGE is applied to A1:A5, B1:B5 react accordingly. I'd
rather do it with Excel's built-in functions instead of resorting to VBA.
Thanks again.
Fernando
"Alojz" wrote in message
...
Even less memory consuming: Highlight A1:A5 and insert my formula in one
shot
(press ctrl+shift+enter after inserting).
|