| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Single list from multiple sheets
I need help on a list project. I have, for example, lists on three separate
sheets. On the first sheet I've got a list A,B,C,D,G. On the second sheet I've got a list A,B,D,E,F,G. And on the third sheet I've got A,G, and H. What I have tried and been unsuccessful to do is get a single list that includes all items included only once (no duplicates). Can anyone recommend a function or tool? Any help would be appreciated. BH |
|
#2
|
|||
|
|||
|
Hi
a manual way: 1. Copy all your list below each other on one sheet 2. Use 'Data - Filter - Advanced Filter' and check 'Unique entries' -- Regards Frank Kabel Frankfurt, Germany "Brian H" schrieb im Newsbeitrag ... I need help on a list project. I have, for example, lists on three separate sheets. On the first sheet I've got a list A,B,C,D,G. On the second sheet I've got a list A,B,D,E,F,G. And on the third sheet I've got A,G, and H. What I have tried and been unsuccessful to do is get a single list that includes all items included only once (no duplicates). Can anyone recommend a function or tool? Any help would be appreciated. BH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| editing multiple sheets at once | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
| CountIF across multiple sheets in a workbook | Excel Worksheet Functions | |||
Linear Mode
