Hello all,
Sorry for the delay getting back to this, was occupied with other things. I wound up using Haseeb's suggestion. Jason - no, order isn't important in my case, where there are duplicates, the lookup can return the labels in any order.
I was hoping to keep everything in named ranges or named formulas but it seems that solution is going to be not possible. (I've created a lookup tab instead.)
I'm going to mark this solved but if you'd like to keep tossing around ideas, I'd be interested in seeing a solution that will work without dumping the array of sorted values into a range.
Thanks all, very very much appreciated!
Keith
Bookmarks