I have a worksheet with two columns of names. Some of the names appear more than once. Is there a formula (not a macro) which can consolidate all of the names into one column, and remove duplicates?
I've attached a worksheet as an example.
Thanks!
I have a worksheet with two columns of names. Some of the names appear more than once. Is there a formula (not a macro) which can consolidate all of the names into one column, and remove duplicates?
I've attached a worksheet as an example.
Thanks!
Please try
=UNIQUE(FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,TRANSPOSE(A4:B59))&"</m></x>","//m"))
or
=FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,TRANSPOSE(A4:B59))&"</m></x>","//m[not(preceding::*=.)]")
Thank You! Second formula works. I'd never used filterxml before!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks