Jimazing Hacks

 If I have a list of items and I want to find out which of them are duplicates, I can use the following formula in another column.  Say the values are in column A… in column B, row 1, I would use this formula:

 =IF(COUNTIF(A:A,A1)>1,”duplicate”, “unique”)

The COUNTIF counts every match of the value in cell A1 with every cell in column A.  The IF condition is whether the results of COUNTIF are greater than 1.  If it is, the cell has duplicate values in the column.

Thanks Will!