Formula with LET/UNIQUE/SORTBY/FILTER

[UT_Princess]

I have a formula where I am trying to pull unique data from columns r/s where s does not equal exclude. I then want to sort it by column r then column s. This formula is the closest I have come and it does everything except apply the filter. Any thoughts?

LET(u,SORTBY('Sheet2'!R:S,'Sheet2'!R:R,,'Sheet2'!S:S,1),UNIQUE((FILTER(u,'Sheet2'S:S<>"EXCLUDE"))))

Here's sample data: B abc C def A def B ghi A abc B EXCLUDE C ghi A EXCLUDE C abc

Result Expected:

A	abc
A	def
B	abc
B	ghi
C	abc
C	def
C	ghi

 

[Cubist]

Try:

Book1
	R	S	T	U	V
1	B	abc		A	abc
2	C	def		A	def
3	A	def		B	abc
4	B	ghi		B	ghi
5	A	abc		C	abc
6	B	EXCLUDE		C	def
7	C	ghi		C	ghi
8	A	EXCLUDE
9	C	abc
Sheet5

Cell Formulas
Range	Formula
U1:V7	U1	=SORT(UNIQUE(FILTER(R1:S9,S1:S9<>"EXCLUDE")),{1,2})
Dynamic array formulas.

 

[UT_Princess]

That worked thank you so much!! I knew I was over thinking it!