| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you combine lists
How do I combine two lists from different files;
File 1 File 2 Mike Mike Dave Larry Jim Sam Harry Dave Pete Helen With a result of: Mike Dave Jim Harry Pete Larry Sam Helen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you combine lists
Copy the two lists into a new worksheet.
(add a header in Row 1) then Data|Filter|Advanced filter and copy the unique values to a different location. Debra Dalgleish has better instructions at: http://www.contextures.com/xladvfilter01.html#FilterUR Mike wrote: How do I combine two lists from different files; File 1 File 2 Mike Mike Dave Larry Jim Sam Harry Dave Pete Helen With a result of: Mike Dave Jim Harry Pete Larry Sam Helen -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Direction combine several excel worksheets, drop down lists and da | Excel Worksheet Functions | |||
| another combine lists question | Excel Discussion (Misc queries) | |||
| Merge/Combine address lists | Excel Worksheet Functions | |||
| Please Help Combine to Two Lists | Excel Worksheet Functions | |||
| How do I combine lists in multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
