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