Create A Unique List From Multiple Tabs Using Formula

C

calummurdo

Hi,

I have six sets of single column data (integers only) on six different
tabs of the same spreadsheet. Each column starts in A2. Each column
may have additional rows added at a later date.

What I would like to do is to list all of the unique values from each
tab into one long column on another tab.

Any help or ideas on how to acheive this using formula would be
greatly appreciated!

Best Regards,

CalumMurdo Kennedy
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Mail Merge Directory Conditional Page Break 0
Find Specific Rows in Range and Create New Tab 18
vlookup across multiple tabs 0
Problem with SET & REF function 0
Mail Merge - List multiple items then page break on unique data 1
Create a list of unique entries based on several columns 1
CountIf from multiple sheets in another workbook 4

Top