Handling duplicate data

Handling duplicate data

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.