Max, to add to what I wrote earlier, Tied scores are returned in the
relitive order as you stated, however name on first tied score is repeated in
all the tied scores. Oh and the 0.00 in the name in the ranking was comeing
from a sum of averages I have at the bottom of the list. So I moved the sum
to a different cell.
Thanks

"Max" wrote:

One way ..

Assuming names in col A, grades (numbers) in col B, data from row2 down

Put in C2:
=IF(B2="","",B2-ROW()/10^10)
Leave C1 blank

Put in D2:
=IF(ROW(A1)COUNT($C:$C),"",INDEX(A:A,MATCH(LARGE( $C:$C,ROW(A1)),$C:$C,0)))

Copy D2 to E2. Select C2:E2, copy down to the last row of source data. Hide
away col C. Cols D & E will return a full descending sort of the names &
grades, inclusive cases with tied scores, if any. Tied scores' cases will be
returned in the same relative order that they appear within cols A and B.
Just read-off the top xx students as desired (or copy and paste special as
values elsewhere).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Neil H" wrote:
I would also like to have a formula that would go into the "Grade Point
Average" column to give me the top student €“ then formula for the 2nd top
student, then the 3rd, on down to ten. Thanks