Index + aggregate

Hi all,

New guy here.
In trying to get top x score and assign to correct name. It does work with LARGE function, but table has duplicate values..

I have tried this but it returns wrong names.


=INDEX(A$2:A$8;AGGREGATE(15;6;ROW(B$2:B$8)-(ROW(B$2)+1)/(B$2:B$8=E2);COUNTIF(E$2:E2;E2)))

Anyone knows how to fix this?

Thanks in advance.
M.

F2=IFERROR(INDEX($A$2:$A$8,SMALL(IF($B$2:$B$8=$E2,ROW($A$2:$A$8)-ROW($A$2)+1),COUNTIF($E$2:E2,E2))),"")

control+shift+enter

copy down

You had one of the brackets in the wrong place, try
=INDEX(A$2:A$8,AGGREGATE(15,6,(ROW(B$2:B$8)-ROW(B$2)+1)/(B$2:B$8=E2),COUNTIF(E$2:E2,E2)))

it works, thanks a lot guys!

You're welcome & thanks for the feedback