Aussie Grid
New Member
- Joined
- Jan 14, 2010
- Messages
- 47
I've created a cote counting page which works fine until there are matching values and it then finds the 1st value only. The top 5 values are in a separate range and this is where the multiple values are read as the first only.(=INDEX($A$12:$AL$35,MATCH(AL6,$AL$12:$AL$35,0),1))
The Total votes column is populated by LARGE(1 - 5) and then Index and Match to get the names matching the totals.
B6-10 Top 5 players
=INDEX($A$12:$AL$35,MATCH(AL6,$AL$12:$AL$35,0),1)
AL6-10 Top 5 totals
=LARGE($AL$11:$AL$34,1)
=LARGE($AL$11:$AL$34,2) etc
A12-35 Players
B12-AK35 Votes
AL12-35 Total of votes
The top 5 results are OK until it meets 2 or more totals the same and then it only enters the name of the 1st instance of the tied scores.
Thankyou in advance for any and all help.
Aussie Grid
The Total votes column is populated by LARGE(1 - 5) and then Index and Match to get the names matching the totals.
B6-10 Top 5 players
=INDEX($A$12:$AL$35,MATCH(AL6,$AL$12:$AL$35,0),1)
AL6-10 Top 5 totals
=LARGE($AL$11:$AL$34,1)
=LARGE($AL$11:$AL$34,2) etc
A12-35 Players
B12-AK35 Votes
AL12-35 Total of votes
The top 5 results are OK until it meets 2 or more totals the same and then it only enters the name of the 1st instance of the tied scores.
Thankyou in advance for any and all help.
Aussie Grid