I have a range of data with 5 columns, containing training courses. I want to create a single list of unique values. I would prefer to use UNIQUE if possible and not an array formula because there data set is very large and the array would be too slow. I don't mind if I need to use 5 different UNIQUE functions and then hide some columns to get my result. Is this possible?
For reference, I have named each range as Course1, Course2, Course3, etc.
Thanks in advance.
Bookmarks