Multiple columns rank

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

So I presume you mean Rank on basis of:

1 - Points
2 - Wins (if Points tied)
3 - Legs (if Points & Wins tied)

The easiest way to do this IMO is to create a unique key based on the above order of preference, using your sample file:

N3: =SUM(M3,I3/100,L3/10000)
copied down to N10

You can then create the RANK using N

O3: =RANK($N3,$N$3:$N$10)
copied down to O10

OK, but hopefully you understand the basic premise of the approach ?

So to correct for my oversight - add in the Tie clause and give it greater weight than that of Legs, eg:

=SUM(M3,I3/100,J3/10000,L3/1000000)

The key is to ensure that the values don't overlap bands.