Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging Databases
I have two worksheets with several columns of data but only have one common
alphanumeric column type, combining in Worksheet 3. I want to keep all Worksheet 1 (new) data. If Worksheet 2 (old) has duplicate in comparable column, then only keep Worksheet 1 data. If not, then old data columns retained. As a bonus, the new worksheet would separate the data. I guess all I really need is the Worksheet 2 filtered data, since all of Worksheet 1 will be retained. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging Databases
Is there any reason you are not storing this "database" in a database?
MH "archsmooth" wrote in message ... I have two worksheets with several columns of data but only have one common alphanumeric column type, combining in Worksheet 3. I want to keep all Worksheet 1 (new) data. If Worksheet 2 (old) has duplicate in comparable column, then only keep Worksheet 1 data. If not, then old data columns retained. As a bonus, the new worksheet would separate the data. I guess all I really need is the Worksheet 2 filtered data, since all of Worksheet 1 will be retained. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do I Match Databases? | Excel Discussion (Misc queries) | |||
Comparing databases | Excel Discussion (Misc queries) | |||
Databases | Excel Discussion (Misc queries) | |||
connecting to databases | Excel Discussion (Misc queries) | |||
DATABASES | Excel Discussion (Misc queries) |