Multiple columns rank

**kollasphotis** · 09-27-2009, 05:30 AM

I am a bit confused.
I have the same problem with multiple columns ranking .

I am trying to make a darts league table:

Cells P7-P14 have the points.
Cells L7-L14 have wins
Cells M7-M14 have ties
Cells O7-O14 have the difference between won and lost games.

The rank should be something like this
Rank1 is the team with most Points
if points equal then more wins
if wins equal then more ties
if ties equal then more won games.

I know the previous guy had only 3 columns to rank but i tried to adjust it to my need with no luck!
CAN ANYBODY HELP ME PLEASEEEEE??????

**DonkeyOte** · 09-27-2009, 05:38 AM

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.

**kollasphotis** · 09-27-2009, 05:49 AM

This is an example of my sheet

**DonkeyOte** · 09-27-2009, 05:54 AM

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

**kollasphotis** · 09-27-2009, 06:01 AM

Close enough.
1 - Points
2 - Wins (if Points tied)
3- Ties (if Points & wins tied)
4- Legs (if Points & Wins & ties tied)

**DonkeyOte** · 09-27-2009, 06:05 AM

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.