Hello Experts,
I want to get formula that able to return custom ranking in the column Rank, with following conditions:
1- If Score2 is highest in the class and there
is no duplicate value then it will be ranked as 1.
2- If Score2 is highest in the class and
there is duplicate value then the record with highest Score1 should be ranked as 1.
See the picture for more understanding.
You can use below Array Formula in E2:
Open in new window
Confirm with Ctrl+Shift+Enter