I have a table like the below, trying to find top 5 attendances using LARGE then INDEX/MATCH
The issue I have is that in GameWeek1, two teams have the same attendance therefore the INDEX/MATCH brings the first one back twice.
For example, in G1:G5 I have the numbers 1 to 5.
In H1:H5 I have...