Creating a ranking list

[ibidem]

Hi,

This is no doubt very easy but it's really bugging me.

I've achieved this with no problems using a button to set a macr
running, but its an ugly solution which I want to sort out.

I have a chunk of data in this sort of format:

Adam - 1
Bill - 3
Charlie - 12
Derek - 5
Echo - 6
Florence - 8

I want to find the top 10 values and also the bottom 10 values - I'v
worked out that I can use the LARGE function to achieve this but I wan
the name to be reported rather than the value.

Any help greatly appreciated

 

[ibidem]

Panic over - found the answer in another post.

doh

 

[Biff]

Hi ibidem,

Here's one way:

=INDEX(A11:A16,MATCH(LARGE(B11:B16,1),B11:B16,0))

A11:A16 holds the names
B11:B16 holds the number value

Biff

 

[ibidem]

Brilliant.

You are a gentleman. Thank you