=IF(ROWS($A$3:A3)<=$A$1,LARGE(IF(SUBTOTAL(2,
OFFSET($C$11:$C$16,ROW($C$11:$C$16)-ROW($C$11),,1)),
$C$11:$C$16),ROWS($A$3:A3)),"")

I need to alter the above formula to remove the duplicates and list the top
(five) highest unique records only.

The table is already in auto filter mode.

Thanks,