Remove dups from 2 columns

[JTL9161]

I have the below 2 columns for data. I am trying to write a formula that will filter out the opposite duplicates. For example there is a BOB/TIM A. and a TIM A./BOB. I only want the unique 5 combinations. Either one just as long as there is only 1 of each combination.

BOB	TIM A.
BRIAN	TED
CHRIS	TIM B.
DAVE	STEVE
PAT	RICK
RICK	PAT
STEVE	DAVE
TED	BRIAN
TIM A.	BOB
TIM B.	CHRIS

What I trying to achieve:

BOB	TIM A.
BRIAN	TED
CHRIS	TIM B.
DAVE	STEVE
PAT	RICK

Thank you in advance,
James

 

[JamesCanale]

I don't have the latest 365 on my rig, but this aught to do the trick.

MrExcelPlayground16.xlsx
	A	B	C	D	E
1	BOB	TIM A.		#NAME?
2	BRIAN	TED
3	CHRIS	TIM B.
4	DAVE	STEVE
5	PAT	RICK
6	RICK	PAT
7	STEVE	DAVE
8	TED	BRIAN
9	TIM A.	BOB
10	TIM B.	CHRIS
Sheet21

Cell Formulas
Range	Formula
D1	D1	=LET(a,A1:B10,b,TAKE(a,,1),c,TAKE(a,,-1),d,IF(b<c,b,c),e,IF(b>=c,b,c),f,HSTACK(d,e),UNIQUE(f))

 

[Fluff]

Another option which seems to work

Fluff.xlsm
	A	B	C	D	E
1
2	BOB	TIM A.		BOB	TIM A.
3	BRIAN	TED		BRIAN	TED
4	CHRIS	TIM B.		CHRIS	TIM B.
5	DAVE	STEVE		DAVE	STEVE
6	PAT	RICK		PAT	RICK
7	RICK	PAT
8	STEVE	DAVE
9	TED	BRIAN
10	TIM A.	BOB
11	TIM B.	CHRIS
Master

Cell Formulas
Range	Formula
D2:E6	D2	=WRAPROWS(UNIQUE(TOCOL(A2:B11)),2)
Dynamic array formulas.

 

[JTL9161]

As always...perfect. Thank you

 

[Fluff]

Glad we could help & thanks for the feedback.