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
Bookmarks