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



--
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.