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

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