LinkBack URL
About LinkBacks
I have two columns of email addresses....A & B. Column B (250 emails) is a subset of Column A (1,400 emails). How can I create a third column that equals only the email addresses in Column A that are not in Column B?
I have two columns of email addresses....A & B. Column B (250 emails) is a subset of Column A (1,400 emails). How can I create a third column that equals only the email addresses in Column A that are not in Column B?
Try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter.
Assuming you emails are in col. A and B starting from row1 i.e. in the range A1:A1400 and B1:B250, then try this...
In C1
and copy down until you get blank cells.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
do you want them in the same row
ie
=IF( COUNTIF(B:B, A1)>0, A1, "" )
and copy down
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Sktneer - I must be doing something wrong. When I paste your formula in Cell C1, it works. When I copy it all the way down to row 1440, every cell shows a blank value. I'm guessing my mistake has to do with your comment "confirm it with Ctrl+Shift+Enter". Can you explain what you mean by this?
After pasting the formula in the formula cell, press F2 (Function Key) --> hold down the Ctrl+Shift keys together --> then hit Enter.
When you confirm a formula as an array formula, you will notice in the formula bar that the formula gets surrounded by the Curly Brackets and if you don't see the curly braces, you may try to re-enter the formula as an array formula by following the steps mentioned above.
And if you type the formula in the formula bar instead of pasting it, don't press Enter alone but hold down the Ctrl+Shift and then hit Enter.
Hi etaf - your formula basically gave us the values in Column B. What I need are the values in Column A that are not also in Column B, ideally with no spaces in between. Is that possible?
I think thats the array formula @sktneerHi etaf - your formula basically gave us the values in Column B. What I need are the values in Column A that are not also in Column B, ideally with no spaces in between. Is that possible?
Thanks Sktneer. It worked !
YW. Glad I could help and thanks for the feedback as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks