Find duplicate values in a spreadsheet

Posted on

Jan,22

 at

3:09 pm

by

jimazing

 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 […]

Filed under: spreadsheet
No Comments »