Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge two data sets one unique
I am attempting to merge two excel worksheets. One has a set of unique ID
numbers with accompanying data. The other has ID duplicative numbers, but I want corresponding info to be copied as appropriate. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge two data sets one unique
"CESTOTT" wrote: I am attempting to merge two excel worksheets. One has a set of unique ID numbers with accompanying data. The other has ID duplicative numbers, but I want corresponding info to be copied as appropriate. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge two data sets one unique
Hi Cestott-
Maybe something like this? In unique ID table, insert a copy of ID column adjacent to ID column In duplicative ID table, insert blank column adjacent to ID column. Use a formula with Row and Concatenate functions to create a unique ID for each ID (ID+ rownumber). Copy unique ID table after duplicative ID table. Sort on new column. Use custom Data filter to select concantenated IDs that start with ID. PB "CESTOTT" wrote: I am attempting to merge two excel worksheets. One has a set of unique ID numbers with accompanying data. The other has ID duplicative numbers, but I want corresponding info to be copied as appropriate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |