a requestion from a beginner.

[jaggedsphere]

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

 

[steve1262]

So you want to delete the duplicates?

 

[barry houdini]

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]

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]

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]

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)

 

[barry houdini]

Here's an illustration.....

Book1
	A	B	C	D
1	banana	apple
2	grape	mango	mango
3	apple	quince
4	strawberry	raspberry
5	raspberry	lemon
6	lemon	pear
7	pear	melon
8	melon	strawberry
9	quince	pineapple	pineapple
10		banana
11		grape
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]

I did just what you said Barry.
it just seems to be a duplicate of column B(fill down step)

excel version 10 and winxp

 

[texasalynn]

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)

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]

oh don't get me wrong...I am really appreciative of the assistance you are all giving me. 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