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