Formula to be applied on rows to compare the data

[Lakshmikanth_2021]

I have input data:

Based on the ranks scored on each subject, I need to rank them, for example, Student 3 score highest on Maths, he gets R1, Student 2 gets R2 and Student 3 gets R3 and the same applies for rest of the 3 subjects..

Basically, I need to apply the if statement on each of the rows data and get the output as attached. 

[Luke_C]

Hi @Lakshmikanth_2021 

No if statements needed, this is just a sorting and labeling exercise:

1. Transpose columns
2. Sort by subject and score
3. Use tile tool to assign ranking
4. Append 'R' to rank
5. Crosstab back and organize data

[Emmanuel_G · Accepted solution]

Hi @Lakshmikanth_2021 ,

An easier way to achieve to output