a requestion from a beginner.

jaggedsphere

New Member
Joined
Oct 11, 2006
Messages
4
OK so I have Column A with emails and Column B with emails.
they do not match. one is an older and one is a newer list.
I need to have the few emails that are the newest ones.
So what I need to be doing is:
remove all emails that there are two of. and end up with a handfull of the latest emails.
Column A has 2500 emails
Column B has 2600 emails
I need that extra 100 emails in its own column.
How do I go about doing this?

Thanks all
Richard
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Try using this formula in C1 copied down column

=IF(ISNA(MATCH(B1,A$1:A$2500,0)),B1,"")

this will give you the emails in B that don't have a match in A

Use Tools > Filter > Autofilter > non-blanks to get a contiguous list
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

put this in C1,

=IF(ISERROR(MATCH(B1,A:A,0)),B1,"")

then copy and paste values into a new column, then do a sort by this new column.

You haven't said what you want to do with the data, or how you want them highlighted.
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458

ADVERTISEMENT

there would be many methods to do this
Try this one
copy all the data into a single column
then do a Data - Filter - Advance Filter
click copy to another location and unique records only and fill in the other ranges as they apply
 

jaggedsphere

New Member
Joined
Oct 11, 2006
Messages
4
sheesh...I am so new at this.
I just cannot seem to make this work. with any of those suggestions.
I can't even seem to be able to copy one column and paste it to the other!
Excel basics are eluding me. I'd better enroll in a course....
There are 2417 in A
There are 2744 in B
There are 327 emails I need to give to someone.(Mr. Picky Pants)
:confused:
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825

ADVERTISEMENT

Here's an illustration.....
Book1
ABCD
1bananaapple 
2grapemangomango
3applequince 
4strawberryraspberry 
5raspberrylemon 
6lemonpear 
7pearmelon 
8melonstrawberry 
9quincepineapplepineapple
10banana 
11grape 
12
Sheet1


You put this formula in Cell C1

=IF(ISNA(MATCH(B1,A:A,0)),B1,"")

Then select C1, put the cursor on the bottom right corner until you see a black + (the "fill handle"). Double click and the formula should "fill down" the column as far as you have values in column B (assuming you have no blanks)

Those entries in B which don't appear in A should appear in column C

Then, as per onlyadrafter's suggestion, select all three columns and use

Data > Sort

sort by column C descending and all the non-duplicates should appear at the top
 

jaggedsphere

New Member
Joined
Oct 11, 2006
Messages
4
:cry:
I did just what you said Barry.
it just seems to be a duplicate of column B(fill down step)
:unsure:
excel version 10 and winxp
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
sheesh...I am so new at this.
I just cannot seem to make this work. with any of those suggestions.
I can't even seem to be able to copy one column and paste it to the other!
Excel basics are eluding me. I'd better enroll in a course....
There are 2417 in A
There are 2744 in B
There are 327 emails I need to give to someone.(Mr. Picky Pants)
:confused:

ok so give a little more feedback. Tell us exactly why you can copy one column and paste it to another? We will help you get there, but you need to help us by give us more detail and where it fails. Hang on - this forum is very helpful and has lots to give you with learning.
 

jaggedsphere

New Member
Joined
Oct 11, 2006
Messages
4
oh don't get me wrong...I am really appreciative of the assistance you are all giving me. :biggrin: I just tend to get impatient with myself...

Ok so I get the formula entered into C1 then I double click the tiny black square on the corner of C1 and the entire column B appears down C. Seems more like it just simply copied the entire contents over.
I tried sorting but that does not seem to take out the unwanted emails.
Am I making sense? Am I giving the right information?
Thank you very large
Richard
 

Forum statistics

Threads
1,137,341
Messages
5,680,926
Members
419,945
Latest member
Carrie Sellers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top