Single List Of Names

[JLouis]

So here we have two columns of names. Some are unique, some are duplicating. I am trying to find a formula that will extract each name only once and list them in column C.

Book1
	A	B	C
1	LIST A	LIST B	LIST OF SINGLE NAMES
2	BOB	LINDA	BOB
3	LINDA	TOM	LINDA
4	CAROL	BOB	CAROL
5	LINDA	CAROL	BRUCE
6	BRUCE	JERRY	CINDY
7	BOB	FRED	TOM
8	CINDY		JERRY
9	TOM		FRED
10	JERRY
11
Sheet1

I've tried a few different formulas from here and the web, but they are mostly looking for unique names and don't include the names that occur more than once. Any assistance is appreciated.

 

[kevin9999]

Book1
	A	B	C
1	LIST A	LIST B	LIST OF SINGLE NAMES
2	BOB	LINDA	BOB
3	LINDA	TOM	LINDA
4	CAROL	BOB	CAROL
5	LINDA	CAROL	BRUCE
6	BRUCE	JERRY	CINDY
7	BOB	FRED	TOM
8	CINDY		JERRY
9	TOM		FRED
10	JERRY
11
Sheet1

Cell Formulas
Range	Formula
C2:C10	C2	=UNIQUE(TOCOL(TRIM(A2:B10),3,TRUE))
Dynamic array formulas.

 

[Peter_SSs]

@kevin9999
I can see why you have TRIMmed the values, but that does end up leaving a blank cell at the bottom of the spilled range which may be an issue if the OP subsequently uses that spilled range for something else. I think changing the order slightly solves that issue.

23 01 06.xlsm
	A	B	C
1	LIST A	LIST B	LIST OF SINGLE NAMES
2	BOB	LINDA	BOB
3	LINDA	TOM	LINDA
4	CAROL	BOB	CAROL
5	LINDA	CAROL	BRUCE
6	BRUCE	JERRY	CINDY
7	BOB	FRED	TOM
8	CINDY		JERRY
9	TOM		FRED
10	JERRY
11
Unique List

Cell Formulas
Range	Formula
C2:C9	C2	=UNIQUE(TRIM(TOCOL(A2:B10,3,1)))
Dynamic array formulas.

 

[kevin9999]

I think changing the order slightly solves that issue.

Yes, that's better Peter (so you spotted the "Linda " with the trailing space )

 

[JLouis]

Incredible Kevin & Peter. Always learning on this site. Never even heard of TOCOL.

Thank you so much.

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.
(TOCOL is pretty new)