List of unique value in different columns

[gtd526]

Hello,
Want a list of unique values from different columns (AI202), not including "Blanks".
Im using the following array but it only lists unique values from a single column (Y).
=INDIRECT(TEXT(MIN(IF(($Y$202:$Y$230<>"")*(COUNTIF($AI$202:AI202,$Y$202:$Y$230)=0),ROW($202:$230)*100+COLUMN($Y:$Y),7^8)),"R0C00"),)&""
I want to modify the array (or new array/formula) to get unique values in Teams(V,Y,AB,AE).

Thank you.
Here is the data:

Wagers.xlsm
	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
201	Team	W/L	SPRD	Team	W/L	SPRD	Team	W/L	SPRD	Team	W/L	SPRD		List Unique Teams
202	UTA	L	-11	BOS	W	-9	NYK	W	-2	BKN	L	3		DEN
203	PHX	L	-12.5	DEN	W	-7	BOS	L	-3	DET	W	3.5		BOS
204	TOR	W	-11.5	SAC	L	-7.5	ATL	L	-2.5	BKN	L	4.5		GS
205	PHI	W	-13.5	BOS	PSH	-9	GS	L	-4.5	BKN	L	2.5		SAC
206				GS	W	-7.5	TOR	W	-3.5	WAS	W	5		LAC
207				SAN	W	-5.5	MEM	W	-3	MEM	L	4.5		SAN
208				LAC	L	-8	PHX	W	-3.5	MEM	L	9		BKN
209				GS	W	-6.5	CHA	L	-2					UTA
210				BOS	psh	-5	NO	L	-2.5					IND
211				UTA	L	-5	CHA	L	-3.5					MIA
212				BKN	L	-5	NO	L	-2					MIL
213				MIA	W	-6.5	DET	W	-3.5					ATL
214				IND	W	-5.5	MEM	W	-4					PHI
215				ATL	L	-5	CHI	W	-1.5					WAS
216				MIL	W	-9	SAC	L	-4					NYK
217				BKN	W	-8.5	GS	L	-2.5					PHX
218				WAS	W	-7	DEN	L	-1.5
219				PHI	W	-5.5	DAL	W	-3
220				SAC	L	-6	CHA	W	-1.5
221				PHX	L	-7.5	IND	W	-4.5
222				PHX	L	-5	CLE	L	-3.5
223				NYK	W	-6	PHX	W	-3.5
224				BKN	W	-9.5	GS	L	-3.5
225				PHI	W	-7	PHX	W	-4.5
226				PHI	L	-8	NO	W	-3.5
227							DET	L	-2
NBA

Cell Formulas
Range	Formula
V202:V227	V202	=IFERROR(INDEX($H$2:$H$9971,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-10),ROW()-ROW($V$201))),"")
W202:W227	W202	=IFERROR(INDEX($A$2:$A$9973,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-10),ROW()-ROW($W$201))),"")
X202:X227	X202	=IFERROR(INDEX($J$2:$J$9972,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-10),ROW()-ROW($X$201))),"")
Y202:Y227	Y202	=IFERROR(INDEX($H$2:$H$9971,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-5)/($J$2:$J$9972>=-9.5),ROW()-ROW($Y$201))),"")
Z202:Z227	Z202	=IFERROR(INDEX($A$2:$A$9973,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-5)/($J$2:$J$9972>=-9.5),ROW()-ROW($Z$201))),"")
AA202:AA227	AA202	=IFERROR(INDEX($J$2:$J$9972,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-5)/($J$2:$J$9972>=-9.5),ROW()-ROW($AA$201))),"")
AB202:AB227	AB202	=IFERROR(INDEX($H$2:$H$9971,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-1)/($J$2:$J$9972>=-4.5),ROW()-ROW($AB$201))),"")
AC202:AC227	AC202	=IFERROR(INDEX($A$2:$A$9973,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-1)/($J$2:$J$9972>=-4.5),ROW()-ROW($AC$201))),"")
AD202:AD227	AD202	=IFERROR(INDEX($J$2:$J$9972,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972<=-1)/($J$2:$J$9972>=-4.5),ROW()-ROW($AD$201))),"")
AE202:AE227	AE202	=IFERROR(INDEX($H$2:$H$9971,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972>=1),ROW()-ROW($AE$201))),"")
AF202:AF227	AF202	=IFERROR(INDEX($A$2:$A$9973,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972>=1),ROW()-ROW($AF$201))),"")
AG202:AG227	AG202	=IFERROR(INDEX($J$2:$J$9972,AGGREGATE(15,6,ROW($H$2:$H$9971)-ROW($H$1)/($J$2:$J$9972>=1),ROW()-ROW($AG$201))),"")
AI202:AI223	AI202	=INDIRECT(TEXT(MIN(IF(($Y$202:$Y$230<>"")*(COUNTIF($AI$202:AI202,$Y$202:$Y$230)=0),ROW($202:$230)*100+COLUMN($Y:$Y),7^8)),"R0C00"),)&""
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Fluff]

How about

+Fluff 1.xlsm
	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
201	Team	W/L	SPRD	Team	W/L	SPRD	Team	W/L	SPRD	Team	W/L	SPRD		List Unique Teams
202	UTA	L	-11	BOS	W	-9	NYK	W	-2	BKN	L	3		UTA
203	PHX	L	-12.5	DEN	W	-7	BOS	L	-3	DET	W	3.5		PHX
204	TOR	W	-11.5	SAC	L	-7.5	ATL	L	-2.5	BKN	L	4.5		TOR
205	PHI	W	-13.5	BOS	PSH	-9	GS	L	-4.5	BKN	L	2.5		PHI
206				GS	W	-7.5	TOR	W	-3.5	WAS	W	5		BOS
207				SAN	W	-5.5	MEM	W	-3	MEM	L	4.5		DEN
208				LAC	L	-8	PHX	W	-3.5	MEM	L	9		SAC
209				GS	W	-6.5	CHA	L	-2					GS
210				BOS	psh	-5	NO	L	-2.5					SAN
211				UTA	L	-5	CHA	L	-3.5					LAC
212				BKN	L	-5	NO	L	-2					BKN
213				MIA	W	-6.5	DET	W	-3.5					MIA
214				IND	W	-5.5	MEM	W	-4					IND
215				ATL	L	-5	CHI	W	-1.5					ATL
216				MIL	W	-9	SAC	L	-4					MIL
217				BKN	W	-8.5	GS	L	-2.5					WAS
218				WAS	W	-7	DEN	L	-1.5					NYK
219				PHI	W	-5.5	DAL	W	-3					MEM
220				SAC	L	-6	CHA	W	-1.5					CHA
221				PHX	L	-7.5	IND	W	-4.5					NO
222				PHX	L	-5	CLE	L	-3.5					DET
223				NYK	W	-6	PHX	W	-3.5					CHI
224				BKN	W	-9.5	GS	L	-3.5					DAL
225				PHI	W	-7	PHX	W	-4.5					CLE
226				PHI	L	-8	NO	W	-3.5
227							DET	L	-2
228
Main

Cell Formulas
Range	Formula
AI202:AI227	AI202	=IFERROR(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$V$202:$V$230,$Y$202:$Y$230,$AB$202:$AB$230,$AE$202:$AE$230)&"</m></k>","//m[not(.=preceding-sibling::m) ]["&ROWS(AI$202:AI202)&"]"),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[gtd526]

How about

+Fluff 1.xlsm
	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
201	Team	W/L	SPRD	Team	W/L	SPRD	Team	W/L	SPRD	Team	W/L	SPRD		List Unique Teams
202	UTA	L	-11	BOS	W	-9	NYK	W	-2	BKN	L	3		UTA
203	PHX	L	-12.5	DEN	W	-7	BOS	L	-3	DET	W	3.5		PHX
204	TOR	W	-11.5	SAC	L	-7.5	ATL	L	-2.5	BKN	L	4.5		TOR
205	PHI	W	-13.5	BOS	PSH	-9	GS	L	-4.5	BKN	L	2.5		PHI
206				GS	W	-7.5	TOR	W	-3.5	WAS	W	5		BOS
207				SAN	W	-5.5	MEM	W	-3	MEM	L	4.5		DEN
208				LAC	L	-8	PHX	W	-3.5	MEM	L	9		SAC
209				GS	W	-6.5	CHA	L	-2					GS
210				BOS	psh	-5	NO	L	-2.5					SAN
211				UTA	L	-5	CHA	L	-3.5					LAC
212				BKN	L	-5	NO	L	-2					BKN
213				MIA	W	-6.5	DET	W	-3.5					MIA
214				IND	W	-5.5	MEM	W	-4					IND
215				ATL	L	-5	CHI	W	-1.5					ATL
216				MIL	W	-9	SAC	L	-4					MIL
217				BKN	W	-8.5	GS	L	-2.5					WAS
218				WAS	W	-7	DEN	L	-1.5					NYK
219				PHI	W	-5.5	DAL	W	-3					MEM
220				SAC	L	-6	CHA	W	-1.5					CHA
221				PHX	L	-7.5	IND	W	-4.5					NO
222				PHX	L	-5	CLE	L	-3.5					DET
223				NYK	W	-6	PHX	W	-3.5					CHI
224				BKN	W	-9.5	GS	L	-3.5					DAL
225				PHI	W	-7	PHX	W	-4.5					CLE
226				PHI	L	-8	NO	W	-3.5
227							DET	L	-2
228
Main

Cell Formulas
Range	Formula
AI202:AI227	AI202	=IFERROR(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$V$202:$V$230,$Y$202:$Y$230,$AB$202:$AB$230,$AE$202:$AE$230)&"</m></k>","//m[not(.=preceding-sibling::m) ]["&ROWS(AI$202:AI202)&"]"),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Works for me. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.