Assign rank to each student based on its Total Marks. (Ex..For highest marks rank should be 1 and so on.)

[Monali_Vekariya]

1. List item

[Eman_Gad]

Please…are this company hiring for employment as customer service from every country…these days or it would be an employment scam …!!!

[Sudharsan_Ka]

HI @Monali_Vekariya

Can you give more details about the query explain your task , share sample input and expected output ?

Regards
Sudharsan

[Monali_Vekariya]

i have a marksheet of all subject and in that i have to found rank and remark
in rank i have to specify :Assign rank to each student based on its Total Marks. (Ex…For highest marks rank should be 1 and so on.)

and in remark i have to specify:
A- EXCELLENT
B-Good
C-Average
F-Fail
can you please help me

[Sudharsan_Ka]

Can you share the input and output with us @Monali_Vekariya ?

[Monali_Vekariya]

Marksheet Data.xlsx (14.4 KB)
in the marksheet i have to calculate remark and rank

[Rahul_Unnikrishnan]

Hello @Monali_Vekariya
Please refer to the below post.

Assign rank to each student based on its Total Marks

Count At_Kt as 1 if subject Mark is less than 40 and calculate total nos of At_Kts. Eg: If any student has less then 40 marks in 2 Subject then ATKT count is 2 ,.If any student has less then 40 marks in 3 subject then ATKT count is 3 Assign rank to each student based on its Total Marks. (Ex…For highest marks rank should be 1 and so on.) note: if someone have aktk then rank will be NA. Marksheet Data.xlsx (11.6 KB) Thank you in advance

Thanks