Dear friends,
There are a total of marks in column ‘AQ’ from cell ‘AQ8’. The end range is not fixed because it’s depending upon the number of students in the class which varies from class to class.
There is a remark in column ‘BE’ from cell ‘BE8’ and the end range is not fixed as mentioned above.
If the student is failed in 1 subject then the remark is ‘F1’
If the student is failed in 2 subjects then the remark is ‘F2’
If the student is failed in 3 subjects then the remark is ‘F3’
If the student is failed in 4 subjects then the remark is ‘F4’
If the student is failed in 5 subjects then the remark is ‘F5’
If the student is failed in 6 subjects then the remark is ‘F6’
If the student is passed in all subjects then the remark is ‘P all’
If the cells are blank then the cells in column ‘BE’ are blank.
I want to give numbers to the students as per their merit in the class. The conditions are as follows:
1. ‘P all’: 1, 2, 3,
2. ‘F1’: continue sequence after ‘P all’ (for example: If there are 5 ‘P all’ students then the ‘F1’ number starts from 6 and so on till ‘F6’)
3. The numbers should base on the total marks in column ‘AQ’. Only the sequence of
numbering is as follows:
P all, F1, F2, F3, F4, F5, F6
Sorry, if the student is failed in 6 subjects then the remark is 'F6' in this case no marks are available in column. It contains 0. So the numbering should be as per their occurance in the result sheet.
Please suggest me a code for it to achieve the target automatically.
For output sample see attached file.
Thanking you in anticipation.
Regards,
Mukesh
Bookmarks