Duplication??

WILFY06

Board Regular
Joined
Oct 13, 2006
Messages
99
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[/i]
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,114,093
Messages
5,545,917
Members
410,711
Latest member
Josh324
Top