Valko,

I tried and its works if I have a single row..

How would I go if I have multiples row meanin:

Term 1 Term 2
Jo 56 55
Mark 98 56
Simon 88 57
Stella 88 58
Jean 50 51

"T. Valko" wrote:

Try this:

Entere as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(A$2:A$6,MATCH(LARGE(B$2:B$6-ROW(B$2:B$6)/10^10,ROWS($1:1)),B$2:B$6-ROW(B$2:B$6)/10^10,0))

Copy down as needed.

Biff

"Will" wrote in message
...
Dear All,

I would like to rank my students but I do face prob if some of them have
the
same marks

Example:

Jo 56
Mark 98
Simon 88
Stella 88
Jean 50

When I uses =large (range, 1) = Mark (tis is correct)
When I uses =large (range, 2) = Simon (tis is correct, its better if it
show
both names)
When I uses =large (range, 3) = Simon (tis is wrong)

Pls help me... thanks