help using lookup and some kind of ranking criteria

[Guest]

Hi,

I have a table like this:

A B
Name January
Tom 150,000
Bob 100,000
Jane 90,000
Lisa 200,000
Fred 50,000

Is there a way to use a lookup function to retrieve all of the names that
are, say, greater than 100K in descending order and all of the names that are
less than 100K in descending order? Sorting is not an option.

My end result should look like:
Lisa
Tom
Bob
Jane
Fred

Thanks!

 

[Pete_UK]

Have a look at this link on Chip's site:

http://www.cpearson.com/excel/rank.htm

This explains a number of ways that you might use to rank data.

Hope this helps.

Pete