Need qucik ranking formula please

DieArd

Board Regular
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.

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Jonmo1

MrExcel MVP
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

Board Regular
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

Board Regular
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

MrExcel MVP
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

Board Regular
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

Board Regular
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!

Replies
2
Views
418
Replies
1
Views
1K
Replies
0
Views
211
Replies
3
Views
418
Replies
8
Views
2K

Threads
1,191,282
Messages
5,985,740
Members
439,978
Latest member
Mr930R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back