Excel -remove all column B cell values from Column A

Greetings,

I have an XLS with a tab: 2 columns of email addresses. I would like to remove all cell values in Column B, from Column A.

Is there an efficient way to do this?

Thank you!
JohnD
bulkChange.xlsx
LVL 1
John DarbyPMAsked:
Who is Participating?
 
Serena HsiMarketing ConsultantCommented:
You could.. in Column C use this formula:

=VLOOKUP($B2,currentlist,1,0)

For column A, I selected everything below the header and named the range as currentlist

Once you have your matches after having copied the formula in Column C; you can select Column C and copy/paste values.

Then Sort by ascending/descending, and delete the rows that show an email address; you can do a find/replace on the #N/A text in that same column.
0
 
Saqib Husain, SyedEngineerCommented:
Enter this formula in C2 and copy it all the way to the end of the data
Apply Autofilter to the data
Filter on column C by unchecking #NA
Clear cell contents from column A
Unfilter
0
 
John DarbyPMAuthor Commented:
Greetings Saqib, which formula are you suggesting? :)
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Saqib Husain, SyedEngineerCommented:
Sorry, the formula is

=match(a2,b:b,0)
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please find the attached in which a conditional formatting in col.B will highlight the emails which are found in col. A and col. C contains a formula that tells you where exactly the email from col. B is found in col. A.
See if this helps.

If you want to delete the emails from col. B, you may apply filter on color and delete the cell contents.
bulkChange.xlsx
0
 
John DarbyPMAuthor Commented:
Thanks guys...let me go look this AM and get back to you! Thanks again!
0
 
John DarbyPMAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.