Re: Find top 10 items in a range

See Chip Pearson's excellent topic "Ranking Data In Lists"

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

Regards,
Peter T

"JPS" <happysandhu@xxxxxxxxxxx> wrote in message
news:uF9FZR41IHA.6096@xxxxxxxxxxxxxxxxxxxxxxx
Great thanks.

Now that gives me the value. I need to now find the corresponding Names
for
example
Column A Column B
Jas 1500
Peter 1200

For the value I want to be able to get the value in column A.

Now the vlookup is not going to work in this instance as the spread***
for
a business reason cannot be sorted on Column B.

Any other ideas?

"Peter T" <peter_t@discussions> wrote in message
news:ONpJE431IHA.4704@xxxxxxxxxxxxxxxxxxxxxxx
Look at the SMALL() and LARGE() work*** functions.

Regards,
Peter T

"JPS" <happysandhu@xxxxxxxxxxx> wrote in message
news:%23$jxRu31IHA.5728@xxxxxxxxxxxxxxxxxxxxxxx
I want to be able to do a report from a single work*** which will
show

The top 10 items
Bottom 10 items

I can use autofilter but autofilter only does one at a time and does it
in
the work*** itself.

I want to be able to show the top and bottom 10 on a seperate list.

Any ideas how this can be done.

Thanks








.