Forum Discussion
Chris2215
Jun 19, 2020Copper Contributor
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...
klivingoodwrightservicecorpcom
Dec 13, 2023Copper Contributor
Perfect.. can you also show how to get it to skip blanks and Null values?
David_pdx
Feb 14, 2024Copper Contributor
klivingoodwrightservicecorpcom
To skip blanks and 0 values use filter().