Index & match - same values

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
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Tie Beaking is one approach. In this approach, names further up in the list are given precedence over lower names, so the "ranking" give seniority when appropriate. An example:

Excel Workbook
ABCDEF
1ScoreRankTop 5Name
2Name1551Name5
3Name21022Name2
4Name3483Name6
5Name4564Name9
6Name51115Name1
7Name693
8Name739
9Name857
10Name964
Sheet2



In this example, only Name1 makes the list as they were the first in the list to score a value that made the top 5. You can adapt that to your needs since you really only want 5 yes?
 
Upvote 0

Forum statistics

Threads
1,224,517
Messages
6,179,240
Members
452,898
Latest member
Capolavoro009

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top