Comparing Data from two excel sheets!
 

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

Comparing Data from two excel sheets!
 

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:

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

Comparing Data from two excel sheets!
 

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

"Stefi" wrote:

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:

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

Comparing Data from two excel sheets!
 

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

"Killer" wrote:

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

"Stefi" wrote:

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:

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

Comparing Data from two excel sheets!
 

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:

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

"Killer" wrote:

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

"Stefi" wrote:

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:

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