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