Column A=Location, Column=Percentage
my formula =Index($A$13:$A$40,Match(Large($D$13:$D$40+Rows($D$13:$D$40)/100,B2),$D$13:$D$40+Rows($D$13:$D$40)/100,0))
The formula doesn't work, it returns nothing but value error. I need to extract the top 5 values includes ties if any with display its adjacent cells values(location). Thank You.
Bookmarks