Hi there,
I have been looking around, but haven't found a solution which suits my current need! I have found a fair few which are macro based / work but only with adjacent columns.
I am looking for a formula (not a macro as my colleagues might find it too confusing I'm afraid!), which is able to pull the values from multiple rows in 3 columns and sort it (ideally A-Z) in another column while ignoring duplicates.
Many thanks in advance for any help!
Nick
Bookmarks