Delete Duplicate Info

  • Thread starter Continental Translations
  • Start date
C

Continental Translations

I have columns A and B filled with information. The information in A1 refers
to B1, A2 to B2 etc..... In some of my cells, there is duplicate
information, and so for example, in A1 and B1, and A22 and B22, the same
text information will be identical.

So, can anybody advise me of a quick way to delete duplicate information if
it appears more than once in both columns??? I don't want to delete
duplicate info from one column but both columns.

Thanks
 
A

Andy B

Hi

If the duplicates are always adjacent, you could use a helper column
=A2=B2
and fill down. Fix these results by Copy / Paste Special . . . Values. You
can then sort on this column to put the duplicates together, to delete them.
For other de-duplicate options see:
http://www.cpearson.com/excel/duplicat.htm
 
Top