Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining worksheets on a unique key column
Hi,
I'm trying to combine several worksheets with text info keying off of a unique id column. Example: One worksheet is Cust ID, Name, Address, etc Another is Name, Lead Eng, Backup Eng Another is ID, Number of Calls, Avg Call Time Another is ID, # of Onsite Visits, Avg Onsite Time, Avg Onsite Bill We want the final One Sheet To Rule Them All to have Cust ID, Name, Address (etc), Lead Eng, Backup Eng, Number of Calls, Avg Call Time, # of Onsite Visits, Avg Onsite Time, Avg Onsite Bill. The ID field is guaranteed to be unique, however a given ID is not guaranteed to appear in any worksheet (for instance, some customers had no onsite visits and thus were not in the onsite sheet.) otherwise I would just sort on ID and copy paste. I tried working with the Consolidate function, but it doesn't seem to want to work with text data. Any help you can give will be appreciated. Thanks in advance. -b |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
How do I set up a column to repeat on other worksheets in Excel | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Combining mutiple columns into one column | Excel Worksheet Functions | |||
count unique with conditions | Excel Worksheet Functions |