Unique formula with several columns

Hello,

I have made an excel to illustrate my question.

I have two columns that give information. I would like to in one column list the unique values/remove duplicates.

The UNIQUE() Formula works well when there is only one column. However when I add another column my ouput also gets placed in another column.

Is there an easy way to fix this?

/Peter

Originally Posted by Bo_Ry

Please try

=UNIQUE(SMALL(C3:D16;SEQUENCE(COUNT(C3:D16))))

Thank you for spending time on answering. It worked on this example sheet. However, in my real data set, I am using non-numerical values and this formula does not seem to work on that. Is it possible to adjuts it slightly to make it work for non-numerical? I've tied using the COUNTA function instead of COUNT but didnt do the job....

Originally Posted by Bo_Ry

Try this
=UNIQUE(FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,C3:D16)&"</m></x>","//m"))

Didnt work

Try:

Please Login or Register  to view this content.

Array formula, ended with Ctrl+Shift+Enter
Hope this helps