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))
- Perfect.. can you also show how to get it to skip blanks and Null values?
klivingoodwrightservicecorpcom
To skip blanks and 0 values use filter().
- Thanks - worked a treat!
Also, the columns don't need to be the same size. - Genius
