Ranking issue
 

This is probably any easy fix. I am trying to learn VBA and excel, bu
here is my problem.

I have a weekly office pool ranking each players correct number o
picks for each week and totaling them up. Then it takes the total an
ranks the players from highest total correct to lowest. That is th
easy part. I have a Marco that ranks the players in order 1-X, i
players have the same overall total then they receive the same ranking
However i have at the bottom of each week column the weekly winner.

What i would like to do is if there is a group of players with the sam
ranking (same overall score). I want to place if the weekly winner a
the top of the ranking.

example:

rank player week1 week2 total
1 a 10 11 21
3 b 10 10 20
3 c 10 10 20
4 d 9 9 18
weekly winner c a

Thanks for any hel

--
Kmorgan2000
-----------------------------------------------------------------------
Kmorgan20004's Profile: http://www.excelforum.com/member.php...fo&userid=1509
View this thread: http://www.excelforum.com/showthread.php?threadid=26725

Ranking issue
 

Hi
not VBA based but have a look at:
http://www.xldynamic.com/source/xld.RANK.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Kmorgan20004" schrieb im
Newsbeitrag ...

This is probably any easy fix. I am trying to learn VBA and excel,
but
here is my problem.

I have a weekly office pool ranking each players correct number of
picks for each week and totaling them up. Then it takes the total and
ranks the players from highest total correct to lowest. That is the
easy part. I have a Marco that ranks the players in order 1-X, if
players have the same overall total then they receive the same
ranking.
However i have at the bottom of each week column the weekly winner.

What i would like to do is if there is a group of players with the
same
ranking (same overall score). I want to place if the weekly winner at
the top of the ranking.

example:

rank player week1 week2 total
1 a 10 11 21
3 b 10 10 20
3 c 10 10 20
4 d 9 9 18
weekly winner c a

Thanks for any help


--
Kmorgan20004
---------------------------------------------------------------------
---
Kmorgan20004's Profile:
http://www.excelforum.com/member.php...o&userid=15090
View this thread:
http://www.excelforum.com/showthread...hreadid=267256