Comparing Data from two excel sheets!

[Guest]

I have sheets created with two columns A1 first name & B1 as the last name in
both sheets. Sheet 1 is my (master) sheet and sheet two is new (data) sheet.

What I want it do is take the information from sheet two (Data) and compare
it to sheet 1 (master) and give me a results of what is not part of the
sheet1 (master) that needs to be added.

Example
Sheet 1 (master)

Saku Koivu
Erik Cole
Danny Markov
Jim Dowd

Sheet 2 (Data)
Saku Koivu
Erik Cole
Danny Markov
Matt Stajan
Jim Dowd


Result
= Matt Stajan

I very new at this stuff so could you please explain it to me in detail.
Any help would be appreciated.

Thanks ahead

 

[Guest]

Enter in the cell B1 in sheet 2

=IF(ISERROR(MATCH(A1,Sheet1!A:A,0)),"Missing","")

and drag it down until the end of your list. "Missing" will be displayed
next to names missing from sheet 1.

Regards,
Stefi

„Killer†ezt írta:

 

[Guest]

Thanks Stefi it's but there's one little problem.

Its two columns not one. I added first ad last name into A1 and it shows the
one missing. The problem I have is there's two columns A1 = first name B1 =
last name

 

[Guest]

Never mind Stefi I found away around it thanks its works perfectly.

 

[Guest]

Sorry, I indeed overlooked that first and last names are in separate columns.
Glad you solved the problem! Thanks for the feedback!
Stefi


„Killer†ezt írta: