Merging of multiple lists

  • Thread starter Thread starter Ron H
  • Start date Start date
R

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
 
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
 
Back
Top