Deleting Duplicate cells function
 

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.

Deleting Duplicate cells function
 

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



--
Gary''s Student - gsnu200811


"Vanessa" wrote:

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.