# rank order by up to 4 progressive criteria

1. ## rank order by up to 4 progressive criteria

Hi all

Haven't posted for a while, but am working on a golf competition spreadsheet that ranks the order of the candidates, eliminating ties.

I have completed the first stage using =RANK(C2,\$B\$2:\$G\$2, )+COUNTIFS(\$B\$2:\$G\$2,C\$2,\$B\$3:\$G\$3,">"&C\$3) which if there is a tie I can resolve it if there is a difference in values in row 3.

However I can't get beyond this, in the event there is still a tie, to look at row 4 etc.

Is this possible given the data and rows available in the attached spreadsheet?

Thanks
Gordon

2. ## Re: rank order by up to 4 progressive criteria

Haven't posted for a while,
You have NEVER posted before with this account ... This was your first post - welcome!

I'll have a look at your workbook.

3. ## Re: rank order by up to 4 progressive criteria

Two proposals.
Rank or ranks
Formula:
`Please Login or Register  to view this content.`

Rank of sums
Formula:
`Please Login or Register  to view this content.`

4. ## Re: rank order by up to 4 progressive criteria

Thanks DJunqueira

I have looked at your suggestions, your first one doesn't produce the correct result. The second one does appear to progress further, but fails if I enter some different numbers into the grid.

To clarify, this should be the intended processing:
If there are ties when ranking row 2, look at row 3 to see if they can be differentiated, (higher number wins)
If there is still a tie, check row 4 for differences.
If there is still a tie, check row 5
If there is still a tie check row 6.

Hope this helps.
Thanks again

5. ## Re: rank order by up to 4 progressive criteria

Lets see this one.

Formula:
`Please Login or Register  to view this content.`

6. ## Re: rank order by up to 4 progressive criteria

Thanks again,

Took my time to consider this suggestion and see how it was working. I also put it into the spreadsheet and played about with entering different values, to see if your calculation worked for different permutations.

So far I have not been able to find a situation where it gives the incorrect rank, when comparing at the scores manually.

I will happily use this formula in future.

Thanks again

7. ## Re: rank order by up to 4 progressive criteria

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1