Want to grade columns A, B & C & come up with a final combined grade in column D.

Hello,

Have three columns that are graded from 1st to 5th or from 1st to 4th.

12 -- 03 -- 06
06 -- 12 -- 01
04 -- 11 -- 11
11 -- 09 -- 03
02

Would like to have those graded so that in column A

12 gets 5 points
06 gets 4 points
04 gets 3 points
11 gets 2 points
02 gets 1 points

Column B

03 gets 4 points
12 gets 3 points
11 gets 2 points
09 gets 1 points

Column C

06 gets 4 points
01 gets 3 points
11 gets 2 points
03 gets 1 points

And then the student with the most points is listed in column D with the total points received in column E from highest to lowest. (Note that I am looking to keep ties listed as ties)

Hoping I can get it to read as follows:

06 8 (points)
12 8 (points)
11 6 (points)
03 5 (points)
01 3 (points)
04 3 (points)
02 1 (point)
09 1 (point)

Spread sheet attached.

Thank you,
Richard

You can get to an unsorted version of what you want with the formula

=IF(ISNA(MATCH(F1,A:A,0)),0,COUNT(A:A)-MATCH(F1,A:A,0)+1)+ IF(ISNA(MATCH(F1,B:B,0)),0,COUNT(B:B)-MATCH(F1,B:B,0)+1)+ IF(ISNA(MATCH(F1,C:C,0)),0,COUNT(C:C)-MATCH(F1,C:C,0)+1)

where the unique list of numbers is in Column F starting in row 1

Take a look at this

This is how I interpreted your problem.