Lookup Problem

[Andrew C]

Hi sample of my spreadsheet

SHEET 1
A B C
1 joe 258 Joe
2 same 201 Sam
3 bob 260 Bob
4 max 258 Max
5 tim 279 Tim

(Column C = a1)

On a seperate worksheet I use =large(sheet1!a1:a5,1) to
give me the highest number and so on down to largest 5.
but beside that number i want to put the name of the
person who got that number.

So in column B i have put =vlookup(a1,Sheet1!
b1:c5,2,false) to return the name of the person.

SHEET 2
A B C
1 279
2 260
3 258
4 258
5 201

My problem occurs when two people have the same number.
it will list the first persons name but wont list the
second one.

Can someone help to fix this or if they have an easier way
of doing it let me know.

Regards

Andrew

 

[Biff]

Hi Andrew,

You do not need to use the Vlookup, try using Rank instead
and then sort the data.

Names in column A.
Scores in column B.
In column C enter this formula:

=RANK(A1,A$1:A$5) and copy down to C5.

Then select the range A1:C5 and sort decending on column C.

I also answered your post about the #Value error when
entering an array formula.

Biff