| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Comparing two Excel sheets | Excel Discussion (Misc queries) | |||
| how do i find data in multiple sheets in excel | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
