(See example at bottom of the post)

Below I am creating excel document to keep stats for a fantasy baseball league. I have listed a catagory (sample) I need to create a formula for column C to give each team their points for the catagory.

The point system is 10 pt for 1st place, 9 for 2nd place, 8 for 3rd....and so on there are 10 total teams.

The problem I have is this...if two or more teams are tied my formula is not working if three or 4 teams are tied.

If teams are tied we add the points together such as ---- 2nd place = 9 pts, 3rd place = 8 pts, 4th place = 7 pts, and then devide by number of teams tied (9+8+7 / 3 = 8). There should be 8 points per team.


My formula is this

=IF(L16=L15,"8.5",IF(AND(L16=L18),"7",IF(L16=L17,"7.5",IF(L16>L17,"8"))))

But it doesn't work if more than two teams are tied.

Column A B C

STOLEN BASES
Baughs & Strikes 145 10
Wilhoite Wolverines 134 8
Steveland Indians 134 8.5
Merry Marlins 134 7.5

Greatful Reds 123 6
August Angels 105 5
Yogi Blairs 98 4
Bedrock Bluejays 97 3
Robinson Rangers 83 1.5
Ivy Leaguers 83 1.5