Ranking issue

[Kmorgan20004]

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

 

[Frank Kabel]

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