View Single Post
  #1   Report Post  
Brian H
 
Posts: n/a
Default 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