Duplication??

[WILFY06]

Hi All,

i would like to check a column for duplicates, its a very large amount of data roughly over 5000 names that i have had to enter and want to make sure i've not done any twice, so i would like a macro button that searches through column C and colours duplicates in RED

Kind Regards,
David

 

[erik.van.geit]

Hi,

it seems like you're happy
one remark:
reading this

to make sure i've not done any twice

don't you just want to get rid of the duplicates anyway ?
check out menu data/filter/advanced filter
check the option "uniques"

kind regards,
Erik