Deleting Duplicate cells function

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

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
How to delete ALL cells containing the same data 0
Cell data entering slow! 0
How to delete ALL cells containing the same data --- REVISED 0
Help please with cut paste and formulas 4
Separating Duplicates?? 2
locating and deleting duplicate cell entries 2
Macro to delte Duplicate rows across multiple sheets 0

Top