Previous Topic Next Topic

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

Answer 1 / 1
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses