Excel: Find Rank and Award accordingly

Here we need to award each group as First, Second, Third, Fourth and Fifth according as the total marks they get in 4 exams. Addition of additional columns are not allowed. So, the Result column must contain words First, Second, Third, Fourth and Fifth as per the marks obtained by the respective group.

Groups 1st Exam 2nd Exam 3rd Exam 4th Exam Result
A 85 87 45 76
B 26 45 85 78
C 85 96 63 62
D 48 49 85 74
E 47 74 58 75
Thanks in advance.

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of August 29, 2014.

For more resources for Microsoft Excel