Multiple columns rank

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