*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 ?
*Thanks in advance.

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.

=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