Need qucik ranking formula please

[DieArd]

Hey everyone,

Please see the pic (link)

http://i48.photobucket.com/albums/f206/dieard/ranking.jpg

I just need a quick formula to give and overall ranking between 1 and 12 next to the names on the bottom using the ranking for figures abovem each was a rank for a particulatr day, I just want an overall .... if you get what i mean,
but i cant figure out how to do it,

Thanks for any suggestions in advance.

Paul.

 

[Jonmo1]

I think you would first need an Average Score for each person in column B

so in B15 and filled down to B26
=AVERAGE(B1:F1)

Giving the Average score for each person.

Than you can put a RANK formula in C15 down to C26

=RANK(B15,B$15:B26)

 

[1Roberta1]

my pc is sooo slow A good 4 minutes slow


I am not sure if this is what you are looking for.

B-F signify days
The numbers in the rows below signify their rank on that day.

If you want an overall rank, I think you would be looking at what the average rank would be for the 5 day period for each person, thus giving you an average of their rank which I think is the Overall rank.

If I have understood you correctly here is how to do it using your example

Place the below formula in cell b15 (Under Overall Rank, Next to Adrian Edwards) and copy down.

=AVERAGE(B1:F1)

Hope this helps.

 

[DieArd]

I think you would first need an Average Score for each person in column B

so in B15 and filled down to B26
=AVERAGE(B1:F1)

Giving the Average score for each person.

Than you can put a RANK formula in C15 down to C26

=RANK(B15,B$15:B26)

Thanks,
Rank 1 in being best, so i guess i just reverse it?

 

[Jonmo1]

Rank 1 in being best, so i guess i just reverse it?

You mean like golf scores, the lower the better?

change
=RANK(B15,B$15:B26)
to
=RANK(B15,B$15:B26,1)

 

[DieArd]

Rank 1 in being best, so i guess i just reverse it?

You mean like golf scores, the lower the better?

change
=RANK(B15,B$15:B26)
to
=RANK(B15,B$15:B26,1)

thats great thankyou for your help.... marvelous!

 

[DieArd]

Rank 1 in being best, so i guess i just reverse it?

You mean like golf scores, the lower the better?

change
=RANK(B15,B$15:B26)
to
=RANK(B15,B$15:B26,1)

thats great thankyou for your help.... marvelous!