Merging of multiple lists

[Ron H]

I have names that appear multiple times in multiple tabs within an Excel
spreadsheet. How can I create a tab which would only show each name once?
Thank you.
Ron

 

[Squeaky]

Hi Ron,

There are several ways to approach this. If you are simply wanting the end
list you can do it this way, however it takes a bit of work but will do what
you want. A dynamic list is a bit more complicated. Hopefully you don't have
too many tabs.
First cut and past EVERY list onto a new sheet so you have one long list of
names. Leave the top cell blank. Lets say your list is in column A starting
at a2.
Highlight the entire list and give it a range name such as "LongList"

in cell b2 insert

{=INDEX(longlist,MIN(IF((COUNTIF($b$1:b1,longlist)=0)*(longlist<>""),ROW(longlist)))-MIN(ROW(longlist))+1)} (without the {} brackets).

Enter it as an array using Control+Shit+Enter to get the brackets, then copy
it down the length of your list. If your list is long it may take quite a
while to display. If you know you only have a certain number of unique
entries then only copy it down that many. Once it has displayed each unique
item it will start displaying #value! You can delete all of those.

If your list is long it will behave very slowly. You can copy/past values of
this list to get rid of the formulas to make it manageable.

Let me know if you have probs.

Squeaky