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.