Is it possible to produce one unique list from two, and preferably in alphabetical order, without resorting to VBA? i.e. a formula solution.
I've attached a sample.
Thanks for any ideas.
Is it possible to produce one unique list from two, and preferably in alphabetical order, without resorting to VBA? i.e. a formula solution.
I've attached a sample.
Thanks for any ideas.
Last edited by BRISBANEBOB; 03-18-2010 at 11:30 PM.
Hi,
Just list List2 under List1 in the same column, then use data filter advanced, selecting the Unique option to filter a list of unique items. Finally sort the filtered list.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Been there, done that...
I was hoping that I could populate the unique combined column with a formula which looks at column 'A' & 'B' and produces the list. I'm trying to avoid manual intervention and VBAs are disabled in the spreadsheet...
Hi Bob,
no macro, but two helper columns, two dynamic range names and two array formulae. The solution is dynamic, so you can add more items to each of your individual lists.
See attached.
Last edited by teylyn; 03-22-2010 at 09:59 PM.
That solution is absolutely stunning - much 'reputation' is being heaped upon you as we speak.
Thank you
matthixson,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks