Unique, Choose, (IF?)

[Silverhorne]

Good day all,

I have been watching a lot of videos from Mr. Excel himself and have learned a lot of good stuff. I am wondering if it is possible to use the Unique Choose formula if a cell on the same row contains a constant value.
I have extracted the unique values based on columns A and C combined in the example below, what I would like to do is only extract these unique values if column E="BW".
Columns B and D are columns with data that is not required and are placeholders, the results I am looking for are in G4:N5.
Maybe I am trying to use the incorrect approach?

Mr Excel Help.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	20	XXX	11.9	XXX	BW		10	10	12	16	18	20	20	30
2	20	XXX	11.9	XXX	BW		12.7	15.9	9.3	12.7	15.9	11.9	12.7	15.9
3	16	XXX	12.7	XXX	BW
4	12	XXX	9.3	XXX	SW		10	16	18	20
5	16	XXX	12.7	XXX	SW		15.9	12.7	15.9	11.9
6	18	XXX	15.9	XXX	BW
7	20	XXX	12.7	XXX	SW
8	30	XXX	15.9	XXX	FW
9	30	XXX	15.9	XXX	FW
10	10	XXX	12.7	XXX	FW
11	10	XXX	15.9	XXX	BW
12	16	XXX	12.7	XXX	BW
Unique Choose

Cell Formulas
Range	Formula
G1:N2	G1	=TRANSPOSE(SORT(UNIQUE(CHOOSE({1,2},A1:A12,C1:C12))))
Dynamic array formulas.

 

[Fluff]

If you have the LET function try

=LET(f,FILTER(A1:C12,E1:E12="BW"),SORT(TRANSPOSE(UNIQUE(INDEX(f,SEQUENCE(ROWS(f)),{1,3}))),,,1))

 

[Silverhorne]

Thank you Fluff! I was looking at posts with the LET function but couldn't get my head around it.
That worked perfectly!

 

[Fluff]

You're welcome & thanks for the feedback