In article ,
MP wrote:

=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,

Try...

=IF(ROWS($A$3:A3)<=$A$1,LARGE(IF(ISNA(MATCH($C$11: $C$16,$A$2:A2,0)),IF(SU
BTOTAL(2,OFFSET($C$11:$C$16,ROW($C$11:$C$16)-ROW($C$11),,1)),$C$11:$C$16)
),ROWS($A$3:A3)),"")

....confirmed with CONTROL+SHIFT+ENTER. Then, I think, the formula for
A1 needs to change as well.

Hope this helps!