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...
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...
Use conditional formatting with a formula of
=COUNTIF($A$1:A1,A1)>1
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
hi xld, thanks...how to use countif formula to a macro statement?
Why VBA, Conditional formatting does it all.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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...
That is what CF does in the manner I showed you.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
If you want all duplicates marked including the original instance, use CF with
=COUNTIF($A:$A,A1)>1
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'