Deleting Duplicate cells function

  • Thread starter Thread starter Vanessa
  • Start date Start date
V

Vanessa

In Excel 2007 there is the "remove duplicate" function, however, I don't want
to delete the rows that have duplicates, I need to clear the cells as this
data is related to specific information in the entire row.
 
Consider data in column A. In another column, say Z, enter:
=A1 and in Z2 enter:
=IF(COUNTIF(A$1:A2,A2)>1,"",A2) and copy down

Coumn Z now replaces duplicated values with blanks. So if "dog" showed up
three times in column A, only the first occurence would appear in column Z
 
Back
Top