highlight all duplicates EXCEPT first instance

**Blake 7** · 12-14-2010, 05:45 AM

Dear Community - good morning.

In Column A I would like to highlight ALL duplicate values EXCEPT the first instance.

I thought this would work but alas!!

=IF(COUNTIF($A:A,A2)=1,FALSE,NOT(COUNTIF($A:A,A2)=1))

If anybody could assist i'd be gratefull.

Thanks

**zbor** · 12-14-2010, 05:51 AM

Use this

=COUNTIF($A$2:$A2, A2)>1

And pull down

**martindwilson** · 12-14-2010, 05:51 AM

=countif($a$1:a1,a1)>1

**Richard Buttrey** · 12-14-2010, 05:53 AM

Hi,

One way in B1 and copied down

Please Login or Register  to view this content.

change row 100 to fit your data.

Rgds

**Blake 7** · 12-14-2010, 05:58 AM

Hi Team!

Thanks all for your responses......worked a treat.

Hope you all have a good day.

**dave_gordon** · 04-26-2012, 07:33 PM

ANy idea how this can be done for a range (D4:M150)?
Regards
Dave

**Trebor76** · 04-26-2012, 08:51 PM

Hi Dave,

I dare say you won't get any replies as your thread is in breach of Rule 2 (see here) of the forum, i.e.

Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread

This is especially the case with older threads.

Regards,

Robert