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...
SergeiBaklan
That's crazy.
You can do it in Google Sheets in one line. Is that really the quickest way?
It depends. If both ranges are of the same known size that could be as
=UNIQUE(INDEX( (tblA[A],tblB[B]), MOD(SEQUENCE(14)-1,7)+1, 1, INT(SEQUENCE(14,,7)/7)))if size=7. Perhaps other variants exist. But again, in Excel there is no UNION operation, at least so far.
SergeiBaklan
I guess a union should be added then.
How do we make that happen?You may add this idea on https://excel.uservoice.com if it doesn't exists, I didn't check.