| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 lists and merge
Hi, Could someone help please, I have 2 worksheets 20 columns in each (both sheets have identical row headers) and 30-40 rows, in column A of both sheets is a field that may or may not appear in both sheets, what I would like to do is merge the information from both sheets and create a master list in sheet3 is this possible? I have attached a sample workbook if this helps! Regards, Sanjay +-------------------------------------------------------------------+ |Filename: merge list.zip | |Download: http://www.excelforum.com/attachment.php?postid=3684 | +-------------------------------------------------------------------+ -- sanjay ------------------------------------------------------------------------ sanjay's Profile: http://www.excelforum.com/member.php...fo&userid=5915 View this thread: http://www.excelforum.com/showthread...hreadid=394780 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare 2 lists and merge
not enough information.
Why not simply move table2 and append it to table1 Are the items in column A supposed to be unique? If so, when the item is on both tables, what data columns do you take - from table1 or table2? Or maybe add them together? "sanjay" wrote: Hi, Could someone help please, I have 2 worksheets 20 columns in each (both sheets have identical row headers) and 30-40 rows, in column A of both sheets is a field that may or may not appear in both sheets, what I would like to do is merge the information from both sheets and create a master list in sheet3 is this possible? I have attached a sample workbook if this helps! Regards, Sanjay +-------------------------------------------------------------------+ |Filename: merge list.zip | |Download: http://www.excelforum.com/attachment.php?postid=3684 | +-------------------------------------------------------------------+ -- sanjay ------------------------------------------------------------------------ sanjay's Profile: http://www.excelforum.com/member.php...fo&userid=5915 View this thread: http://www.excelforum.com/showthread...hreadid=394780 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare 2 lists and merge
Sorry Patrick, I hope this makes sense: Sheet 1 ID B C D A1 2 4 A2 3 5 A4 4 4 A5 5 5 Sheet 2 ID B C D A1 3 4 A2 1 3 5 A3 5 6 7 A6 6 6 6 Sheet 3 (merged sheet) ID B C D A1 2 3 4 A2 1 3 5 A3 5 6 7 A4 4 4 A5 5 5 A6 6 6 6 Regards, San -- sanja ----------------------------------------------------------------------- sanjay's Profile: http://www.excelforum.com/member.php...nfo&userid=591 View this thread: http://www.excelforum.com/showthread.php?threadid=39478 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare 2 lists and merge
what if
Sheet 1 ID B C D A1 2 4 A2 3 5 Sheet 2 ID B C D A1 3 4 A2 1 4 5 in A2 column C. would you take the 3 or the 4? "sanjay" wrote in message ... Sorry Patrick, I hope this makes sense: Sheet 1 ID B C D A1 2 4 A2 3 5 A4 4 4 A5 5 5 Sheet 2 ID B C D A1 3 4 A2 1 3 5 A3 5 6 7 A6 6 6 6 Sheet 3 (merged sheet) ID B C D A1 2 3 4 A2 1 3 5 A3 5 6 7 A4 4 4 A5 5 5 A6 6 6 6 Regards, Sanj -- sanjay ------------------------------------------------------------------------ sanjay's Profile: http://www.excelforum.com/member.php...fo&userid=5915 View this thread: http://www.excelforum.com/showthread...hreadid=394780 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare lists | Excel Discussion (Misc queries) | |||
| Compare two lists | Excel Worksheet Functions | |||
| compare two lists | Excel Worksheet Functions | |||
| compare and merge lists in separate worksheets | Excel Worksheet Functions | |||
| Compare Lists | Excel Discussion (Misc queries) | |||
Hybrid Mode
