Hi pals. I am creating an excel to rank the achievement of pupils. Please help me to write a formula to rank them according to multi column and criteria:
1. Rank those with 0 Grade E first, then only follow with those with >0 Grade E
2. For those with 0 Grade E, rank Grade A, follow by Grade B, C and D
3. For those with >0 Grade E, rank Grade A, follow by Grade B, C, D and E
Thanks in advanced.
1. Rank those with 0 Grade E first, then only follow with those with >0 Grade E
2. For those with 0 Grade E, rank Grade A, follow by Grade B, C and D
3. For those with >0 Grade E, rank Grade A, follow by Grade B, C, D and E

Thanks in advanced.