Tuesday, February 22, 2011

Formula to detect duplicate cells in Excel

For when you have a column with values that may or may not contain duplicates. Sort the column A-Z etc and apply the following formula to the column next over.

=IF(C2=C3, "copy", "unique")