Large formula not returning desired results

[Climaxgp]

Hi Guys

I'm trying to Rank cells V4 from highest to lowest. I have a LARGE formula in place but it doesnt seem to be working out. It does not give me everyone from A4:A50. It also duplicates the figures.

In cell U4 i match V4 and it pulls a name associated with that average but this does'nt seem to work out as well cause it duplicates the names.

I hope i'm making sense here..

[DonkeyOte]

based on your file I think you need:

U4:
=IF($V4="-","",INDEX($A$4:$A$50,MATCH(1,INDEX(($T$4:$T$50=$V4)*ISNA(MATCH($A$4:$A$50,$U$3:$U3,0)),0),0)))
copied down

rather than

U4:
=IF(V4=0,"",INDEX($A4:$A50,MATCH(1,INDEX(($T$4:$T$50=$V4)*ISNA(MATCH($A$4:$A$50,B$53:B53,0)),0),0)))

ie the test for unique name should be conducted against prior results (U3 onwards) and name range reference should be fixed - given your formula in V your pre-emptive IF should look for hyphen rather than 0.

[Climaxgp]

Thanks buddy!!

It works!