TEST of XL2BB Spilling formulas.

[DRSteele]

When a formula spills using the new Dynamic Array calculation engine, let's see what happens.

Book1
	A	B	C	D	E
1	design	foreground	background	size	type
2	plain	white	black	XL	T-shirt
3	plain	white	black	M	T-shirt
4	plain	brown	yellow	L	cap
5	paisley	blue	yellow	L	cap
6	paisley	blue	yellow	M	T-shirt
7
8
9	colour combinations used
10	white black
11	brown yellow
12	blue yellow
13
14
15	colour combinations per design
16	plain	paisley
17	white black	blue yellow
18	brown yellow
Sheet38

Cell Formulas
Range	Formula
A10	A10	=UNIQUE(B2:B6&" "&C2:C6)
A16	A16	=TRANSPOSE(UNIQUE(A2:A6))
A17:B17	A17	=UNIQUE(FILTER($B$2:$B$6&" "&$C$2:$C$6,$A$2:$A$6=A16))

 

[DRSteele]

It posts nicely for the upload. But copying from the Forum here back to the spreadsheets yields this, complete with the #SPILL error. I have to delete the text below the spilled formulas (like in A11 and A12) to quash the error. Also, the colours did not paste either.