Single list from multiple sheets

B

Brian H

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
 
F

Frank Kabel

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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for looking up and copying from another worksheet? 1
Lookup Across Multiple Rows / Columns 5
Help with lots of formulas 3
Determine Resource Allocations by evaluating available time and required time. 3
Single column to multiple columns 5
Converting excel to PDF, single page converts to multiple HELP! 1
Macro Help 1
Match a group of cells with another group of cells 1

Top