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