Deleting cells with same data as other cell

Closed
Blakey - Mar 4, 2010 at 05:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 07:38 AM
Hello,

I am trying to do the following in relation to two mailing lists in Excel.

1. Identify the email addresses in one list that are the same as in the other list.
2. Delete the email addresses in the first list that are the same.

One list is in Column A, the other in Column G in one work sheet.

Is there a formula or VB script to do this? Is there a way of doing the same task but just searching for part of an email address and deleting any duplicates?

Much appreciated.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 4, 2010 at 07:38 AM
You can use MATCH function to find dup for situation number 1

When you say you want to delete the dups from list 1, I presume you are talking about the cell deletion and now row, so the question would be how should cells arrange, move up, move right etc