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...
use VSTACK(arr1,[arr2]...) to UNION two or more arrays.
then apply Unique to the result.
=UNIQUE(VSTACK(A1:A100,B1:B100))
then apply Unique to the result.
=UNIQUE(VSTACK(A1:A100,B1:B100))
Thanks - worked a treat!
Also, the columns don't need to be the same size.
Also, the columns don't need to be the same size.