Creating a ranking list

  • Thread starter Thread starter ibidem
  • Start date Start date
I

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
 
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
 
Back
Top