31 August 2013
Handling duplicate data is well-known to be a vexing problem for many Excel users.
There are tools within Excel that simply delete all duplicate data, but there are times when it is more advisable to identify these duplicate values prior to eliminating them. Conditional Formatting can offer an excellent solution.
Full article: Handling duplicate data