As in the attachment, using Excel 2007, I have a record of students' marks of 5 lessons (actually they are 15 lessons but I give a sample of 5)
Each student has the right of 3 attempts to pass the exam.
What I'm looking for is, how to let Excel writing the final result of each student in letters.
For example:
Pass in 1st attempt;


Pass in 2nd attempt;
Pass in 3rd attempt; or
Fail.

Please, see the attached file.

Thanks.

Attached Files

3-attempt exam.xlsx (14.1 KB, 12 views)