Forum Discussion
UNIQUE function two columns
I have two columns, A on one sheet, B on another. I want to return a third column which is the unique values that appear in these columns. Something like =UNIQUE(A:A,B:B) doesn't quite work. W...
I would go with Patrick2788 's solution.
= UNIQUE(TOCOL(A:B, 1))Not that I like the use of entire column referencing; it always strikes me as a 'quick and dirty' practice unless you know in advance that there are precisely 1048576 values.