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
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,113,848
Messages
5,544,640
Members
410,627
Latest member
georgealice
Top