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

Entire Row Duplicates 6
locating and deleting duplicate cell entries 2
Duplicates Deletion ? 2
duplicate cells 1
Eliminate Duplicate Row 1
how do i combine excel worksheets 1
Duplicate Rows 2
remove duplicates but retain one not delete both 4

Top