I am a teacher, and I am working on my student’s broadsheet.
I have a table of rows and columns (A6:X6) representing the details of one student (S/N, Name, 9 different subjects, total score, percentage, position and remark), and I have 52 students (A6 down to A62)
This is what I need help with
1- How can I make position to reflect in this format (1st, 2nd, 3rd,…) putting into consideration those with the same percentage
2- I desire to have a replica of this sheet whereby as I input data into this sheet, all rows and column peculiar to an individual will be auto sorted in the replica sheet based on the position Column
Thank You
I have a table of rows and columns (A6:X6) representing the details of one student (S/N, Name, 9 different subjects, total score, percentage, position and remark), and I have 52 students (A6 down to A62)
This is what I need help with
1- How can I make position to reflect in this format (1st, 2nd, 3rd,…) putting into consideration those with the same percentage
2- I desire to have a replica of this sheet whereby as I input data into this sheet, all rows and column peculiar to an individual will be auto sorted in the replica sheet based on the position Column
Thank You
