INDEX/MATCH with =LARGE is giving duplicates

Hello again Forum!

Last issue and dashboard should be complete!

I was having an issue with sort last week and a GREAT forum member pointed me in direction of =LARGE (Column CU), and =INDEX/MATCH to pull rest of the rows.
This worked great until today... when an agent had 0 $PH (Column CU)
this resulted in many duplicate rows throwing whole KPI off as you will see in example (pulled directly from original with sensitive removed)


Anyone have an idea how to get around this and still keep =Large function, as the rest of my report is built around this table.

Try this...
=IF(OR(CU1="",LARGE($BC$1223:$BC$1521,ROW(AZ1))=CU1),"",IFERROR(LARGE($BC$1223:$BC$1521,ROW(AZ1)),""))

Happy to help

see attached if it fulfills your requirements
i used advanced filter and then sort afterwards

i attached a picture of what i used to create the advanced filter
basically
list range is the area in question

Criteria is the 2 rows at the top
*note formula in cell DE2
which is

Formula:

Please Login or Register  to view this content.

Copy to range
just copies it to where you want it...ps without VBA you cannot copy to another sheet

after which you can just sort by PH

and of course you would be able to do it as a macro later if it works for you