Hi all I have tried to search and have tried a few ideas but none seem to be working
In column F of a sheet names Reflection Referrals I have multiple word based inputs
I need somehow from that list to create a drop down list of all of the entries but condensed into a unique list on a new sheet called sheet 1
so in I have
Halifax
Halifax
London
Newcastle
Brighton
Poole Brighton
Halifax
I get a list
Brighton
Halifax
London
Newcastle
Poole
Preferably without the Blanks and dupes and if poss in alphabetical order.
I can use Macros. Is this possible
Bookmarks