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-19-2010 at 12:30 AM.
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
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my 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 10:59 PM.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
That solution is absolutely stunning - much 'reputation' is being heaped upon you as we speak.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks