specific rank in column value - which function?!

[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

 

[Frank Kabel]

Hi
see your other post