How to use Rank with 2 Condition

Hello,

I need an advice and appreciate your help.

I would like to do a ranking on a spreadsheets. however there are 2 condition that I need to include. 1). is the highgest total points then 2) is the highest score

Could you please advice how to do this?

I have attached the sample files.

Many Thanks

Dear Friend,

Please find the attachment along with Certain details updated which could be usefull to you for ranking to update in your spread sheets.

The Highlighted colors are of formulaes which are Important for analysing a ranks for any sort of report.

Thanks

Surya.

Hello Surya,

Thanks for the reply. However the ranking that I need are base on the Points first then Score.

Example:

Points Score Rank
24 100 (2)
24 99 (3)
24 105 (1)
23 200 (4)

Kindly advice.


Many Thanks
Raymond

What I usually do is add a dummy column (which can be hidden). I multiply the primary criteria by a number large enough that it doesn't interfer with the secondary number (in your case 100,000) and add to the secondary number. Then I perform the RANK on that column. See example.

Does this work for you?

ChemistB

This is exactly what I'm looking for and it is simple and work perfectly. Many Thanks ChemistB

Cheers
Ray