hiding font of same name leaving first to unhide

[paradise2sr]

Hi all of you,

In the enclosed workbook,I want to hide which have duplicates in column A leaving the first item to be unhide.Pls note that I do not want to hide rows rather only duplicates leaving unhide first one.Something like fonts to get white in colour duplicate one.

Thanx in advance.

With Rgds,

Suresh

[samba_ravi]

Select Entire Column A and use below formula in Conditional format
=COUNTIF(A$1:A1,A1)=1

Please Login or Register  to view this content.

and choose color of your choice

[paradise2sr]

Hi,
Thanks for the reply.

The above formula is hiding the first one .I want to hide from 2nd onwards and hence only the first and unique remaining unhidden.

Kindly see the enclosed workbook with your formula in conditional formatting.

[Tony Valko]

Change the formula to:

=COUNTIF(A$1:A1,A1)>1

[paradise2sr]

Change the formula to:

=COUNTIF(A$1:A1,A1)>1

Thanx,it did worked.

[Tony Valko]

You're welcome. Thanks for the feedback!