Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare and merge lists in separate worksheets
I have 2 worksheets with long lists. Each list has additional columns with
data, but not found in the other. I want to compare and merge items listed so all data in all columns are combined in separate worksheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare and merge lists in separate worksheets
Hi EAH:
There are a couple of options that I use if all the master data is the same on both sheets. 1. copy the key and the extra data on the second worksheet to the first worksheet and them do a match using = to make sure the keys agree. (You may need to sort the data before copying to make sure it is in the correct order. 2. You vlookup on the first worksheet to get the data from the second worksheet. You can check for missing rows first by adding an extra column on both worksheets checking for missing data using vlookup and checking for #n/a. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "EAH" wrote: I have 2 worksheets with long lists. Each list has additional columns with data, but not found in the other. I want to compare and merge items listed so all data in all columns are combined in separate worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare and merge two separate documents? | Excel Discussion (Misc queries) | |||
Compare Data in two Separate Worksheets | Excel Discussion (Misc queries) | |||
Formula to compare two lists and separate non-recurring items? | Excel Worksheet Functions | |||
Compare data on 2 separate worksheets. | Excel Worksheet Functions | |||
How to compare the lists in two columns & separate odd one ? | Excel Discussion (Misc queries) |