close
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!
Have a look at this link on Chip's site:
www.cpearson.com/excel/rank.htm
This explains a number of ways that you might use to rank data.
Hope this helps.
Pete
全站熱搜
留言列表
