Create an automatically sorting/ranking list

[dip11]

Hi,

I have 1 group of people (8 people total) who each have 2 scores (16 scores total)

I have already calculated the scores and now want to use a blank space on my sheet to create a ranking table of the 8 individuals based on their scores.

The criteria will be:
If Score1 is lowest, rank best
If Score1 is tied, rank based on Score2
If Score1 and 2 are tied, I don't care (well, tank alphabetically by the label's name or so, whatever you like)

Thanks!

[oeldere]

For score 2 you can do it the way i showed in the file.

[dip11]

Hm I see you auto ranked Score2 and then matched the Person to that score.
However, for my problem I need to rank by Score 1 then by the associated Score 2 and then match the correct person to the scores.

[oeldere]

See a2 : c10

Please reply if this is what you're up to.

[dip11]

Yes that works - I was wondering though if its possible to make this any simpler?

[oeldere]

Maybe it can.

In that case wait for other reaction of other forummembers.

[dip11]

Actually I just double checked your solution and it did not work when I changed some values around, say swapping Score2 for Lina and John.

[Teethless mama]

See the attached

[dip11]

Thanks, that's fairly good, though it seems to duplicate an entry if the 2 scores are the same and skip the other person with the same score.
i.e. changing John to 10/20 will display John twice instead of John and Lina

[icestationzbra]

in cell N3, you could use this tweaked version of @teethless mama's formula:

Please Login or Register  to view this content.

drag-fill down...

then change Holly's score (for example) to 10/20 (same as John's); now observe that Output column has Holly and John displayed separately.

[Teethless mama]

Thanks, that's fairly good, though it seems to duplicate an entry if the 2 scores are the same and skip the other person with the same score.
i.e. changing John to 10/20 will display John twice instead of John and Lina

OK, then try this:

[dip11]

Teethless mama:
I changed Holly's score to 10/50 so that there were 3 people with Score1 of 10, 2 with Score2 of 20 and 1 with Score2 of 50. It ranked them as 10/20, 10/50, 10/20

Using icestationzbra's formula fixed it

Thanks all!