Unique List from 2 Columns Using TextJoin and Unique if possible

[Stephen_IV]

I use TextJoin and Unique to get Unique data in 1 cell. What I am looking to do is is to get unique data from 2 columns into 1 cell. In D1: Steve, Mike, Jay, Mary, Ray, Al

This is the formula that I use for 1 cell: =TEXTJOIN(", ",,UNIQUE(A1:A5)). I would like to do something like, =TEXTJOIN(", ",,UNIQUE(A1:B5)) in 1 cell. Thanks in advance!!!!

Book1
	A	B
1	Steve	Ray
2	Steve	Mike
3	Mike	Mike
4	Jay	Steve
5	Mary	AL
Sheet2

 

[Aladin Akyurek]

Nope, just what you would expect. There is a second argument to UNIQUE(), if omitted or false, returns unique rows, and if true returns unique columns. Each row is distinct (each pair of cells is unique), so the entire input range is returned.

I see some discussion and description attemps focused on a distinction between 'unique' and 'distinct' involving the UNIQUE() function. How does Longre's UNIQUEVALUES() behave when fed with a multiple row and multiple column range?

 

[Jon Peltier]

I am not familiar with Laurent's functions.