Hi, am not sure whether without, but definitely possible with auxiliary column.
Array enter in E10:E14 =A10:A14+B10:B14+C10:C14+D10:D14
Insert in F10:F14 ur label.
To see correctly sorted labels in B2:B5, array-enter:
=VLOOKUP(LARGE(($E$10:$E$14),ROW()),$E$10:$F$14,2, 0)
To see labels correctly sorted u do not even need A1:A5, as formula sorting
labels does not use it referring to auxiliary column E. So, if u need to see
just labels sorted, u can delete A1:A5.

"Fernando Ronci" wrote:

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).