Deleting cells with same data as other cell

Closed
Blakey - Mar 4, 2010 at 05:49 AM
rizvisa1
Posts
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0