1. Registered User
Join Date
Jul 2003
Location
Australia
Posts
217

*I have a worksheet which looks similar to this :

Name Score
A 60
B 80
C 50
D 90
E 70
F 65
... ...

*On another worksheet, I have these columns :

Rank Name
1
2
3
4
...

*They are ranking the persons in terms of their scores.
*What formulas should I place into the second column (Name) to obtain the names ?

2. Registered User
Join Date
Oct 2003
Posts
1,091
Howdy. Let's assume that your list is in \$D\$4:\$E\$9. Then in \$G\$4:\$G9 put the numbers: 1-6

In cell H4, put this formula:

=LARGE(\$E\$4:\$E\$9,\$G4)

Copy down to row 9.

Then in I4 put this formula:

INDEX(\$D\$4:\$E\$9,MATCH(H4,\$E\$4:\$E9,),1)

Copy down to row 9.

If you use the relative and absolute references correctly, you can extend each list with little effort.

3. Registered User
Join Date
Oct 2006
Posts
9
=RANK(J5,\$J\$5:\$J\$10,0)
=RANK(J6,\$J\$5:\$J\$10,0)
=RANK(J7,\$J\$5:\$J\$10,0)
=RANK(J8,\$J\$5:\$J\$10,0)
=RANK(J9,\$J\$5:\$J\$10,0)
=RANK(J10,\$J\$5:\$J\$10,0)

in one cell enter =rank(

then hit the function wizard, to get help with this function

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•