I have a worksheet with around 6000 lines of data.
I'm trying to get a sorted (using the SORT function) list of unique (using the UNIQUE function) values from columns I & J on a separate sheet in a single column (using the TOCOL function), but excluding any value that contains either + or @ symbols (using the FILTER function).
I've tried every possible combination of SORT / UNIQUE / FILTER / TOCOL but I simply can't get the filter item to work without adding a helper column, which I'd rather not do.
The source data in columns I & J has a dynamic named range ('Stations") so I don't need to specify the data area as this will be added to over time.
Can anyone help with a clean solution please?
An example of what I'm trying to achieve is as follows:
Column I Column J Output A K A B + C C A B + D D A E E D F G @ F H G @ E J H J K B + A C I +
As always, any assistance would be hugely appreciated, and thank you so much in advance.
Bookmarks