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.
Bookmarks