Hi,
Please I'm working on a score sheet for a school. I created a sheet for each student containing their scores in each subject and the total score is in cell B34 of each sheet.
I want the position of each student to display in cell H10 of each sheet according to their scores, i.e. 1st, for highest score, 2nd for second highest score, 3rd, 4th, 5th, etc...
Attached is a copy of the workbook , please help me. I will be very grateful if I can get a solution.
***THE PASSWORD OF THE FILE IS (olaide)
Thanks.
Bookmarks