Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick way merge 2 databases using a unique field.
Hi Gurus,
I have 2 databases containin details of the same unique field eg serial number Is there a simple quick way to merge them by the unique serial number if the 2 databases are found on different sheets of the same work book ? Database 1 serial_number Field1 Field2 0001 xxx xxx 0002 xxx xxx .. . . .. . . 0xxx xxx xxx Database 2 serial_number Field3 Field4 0001 xxx xxx 0002 xxx xxx .. . . .. . . 0xxx xxx xxx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique records in a field | Excel Discussion (Misc queries) | |||
Merge two lists to get one with unique records | Excel Discussion (Misc queries) | |||
merging 2 excel databases using unique identifiers | Excel Discussion (Misc queries) | |||
merge two data sets one unique | Excel Discussion (Misc queries) | |||
Merge an alpha field and a numeric field | Excel Discussion (Misc queries) |