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
