Rank based on 2 columns

[James_Latimer]

Excel - O365

Hi all,

I'm having a mental block and need some help from the ever amazing Excel gurus.

I have two columns of values, 'number of submissions' and '% won'. I want to rank my data based on % won (descending), then based on that use number of submissions (descending).
So...

Ideally i need the ranks to be unique too (which is adding to my headache) so that i don't get duplicate ranks.

I've looked at this for so long that i'm starting to question whether some of these words i'm reading even exist...

Thanks in advance to anyone who can offer me some assistance.

 

[steve the fish]

This isnt going to prevent duplicate ranks if both criteria are the same but id have thought the point of the 2nd criteria is to negate that chance? Anyway you could try:

=RANK(B2,$B$2:$B$4)+COUNTIFS($B$2:$B$4,B2,$A$2:$A$4,">"&A2)

 

[DRSteele]

I take it that you wish to rank items using tiebreakers. See if this Article helps you.