PDA

View Full Version : Solved: Column Values Duplicate



joms
03-13-2009, 07:12 AM
Hi guys, this might be a common problem...but how to detect duplicate values in a single column and change the color of the duplicata data, to indicate that it's a duplicated value?

thanks... :)

Bob Phillips
03-13-2009, 07:16 AM
Use conditional formatting with a formula of

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

joms
03-13-2009, 08:23 AM
hi xld, thanks...how to use countif formula to a macro statement?

;)

Bob Phillips
03-13-2009, 09:12 AM
Why VBA, Conditional formatting does it all.

joms
03-13-2009, 05:57 PM
thanks xld, why i want vba because i want to put a color on the cell which is duplicated... anyway thank you so much for your help... :)

Bob Phillips
03-14-2009, 01:57 AM
That is what CF does in the manner I showed you.

mdmackillop
03-14-2009, 05:52 AM
If you want all duplicates marked including the original instance, use CF with
=COUNTIF($A:$A,A1)>1