Say I have 100 records from Row 2 through Row 101
Col A -- Name
Cols B through AE -- data
Cols AF through AJ -- calculated ratios
I can generate lists of the top values in Col AF by
=LARGE(AF2:AF32,1)
=LARGE(AF2:AF32,2)
etc.
How can I return the names associated with =LARGE(AF2:AF32,n), so I get a listing like this, for example?
Name High
Anton 17.02
Baker 16.11
Smith 14.09
I tried using OFFSET(LARGE(AF2:AF32,1),0,-31) but I couldn't get it to work.
Thanks,
Cliff
Col A -- Name
Cols B through AE -- data
Cols AF through AJ -- calculated ratios
I can generate lists of the top values in Col AF by
=LARGE(AF2:AF32,1)
=LARGE(AF2:AF32,2)
etc.
How can I return the names associated with =LARGE(AF2:AF32,n), so I get a listing like this, for example?
Name High
Anton 17.02
Baker 16.11
Smith 14.09
I tried using OFFSET(LARGE(AF2:AF32,1),0,-31) but I couldn't get it to work.
Thanks,
Cliff