specific rank in column value - which function?!

  • Thread starter Thread starter Hannah Madsen
  • Start date Start date
H

Hannah Madsen

Hi
I have a column of names, with a column of values next to it that
corresponds. The column is about 100 values long.

I want a table that says
Highest Value / name
2nd Highest Value / name
3rd Highest Value / name
3rd Lowest Value / name
2nd Lowest Value / name
Lowest Value / name

I don't want to use the rank function because i don't want a seperate column
next to my data with its ranks, also because the column is always being
added to

I just want a function that does "look in column B, find rank x, return name
from column a", that ignores blank values.

Thanks!

Hannah
 
Back
Top