Fill boxes based on binary value

[tezza]

Hi All

Any idea how I create boxes of number based on their binary number?

Initially, I'm only looking to fill 6 boxes, so 1 - 63

1	3	5	7						2	3	6	7						4	5	6	7
8									16									32
1	00001
2	00010
3	00011
4	00100
5	00101
6	00110
7	00111
8	01000

 

[tezza]

Ok, how about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		1	3	5	7	9	11	13	15			2	3	6	7	10	11	14	15
3	card 1	17	19	21	23	25	27	29	31		card 2	18	19	22	23	26	27	30	31
4		33	35	37	39	41	43	45	47			34	35	38	39	42	43	46	47
5		49	51	53	55	57	59	61	63			50	51	54	55	58	59	62	63
6
7		8	9	10	11	12	13	14	15			16	17	18	19	20	21	22	23
8	card 4	24	25	26	27	28	29	30	31		card 5	24	25	26	27	28	29	30	31
9		40	41	42	43	44	45	46	47			48	49	50	51	52	53	54	55
10		56	57	58	59	60	61	62	63			56	57	58	59	60	61	62	63
11
Data

Cell Formulas
Range	Formula
B2:I5	B2	=AGGREGATE(15,6,$B$13:$B$75/(MID($C$13:$C$75,6,1)="1"),COLUMNS($B2:B2)+ROWS(B$2:B2)*8-8)
L2:S5	L2	=AGGREGATE(15,6,$B$13:$B$75/(MID($C$13:$C$75,5,1)="1"),COLUMNS($B2:B2)+ROWS(B$2:B2)*8-8)
B7:I10	B7	=AGGREGATE(15,6,$B$13:$B$75/(MID($C$13:$C$75,3,1)="1"),COLUMNS($B2:B2)+ROWS(B$2:B2)*8-8)
L7:S10	L7	=AGGREGATE(15,6,$B$13:$B$75/(MID($C$13:$C$75,2,1)="1"),COLUMNS($B2:B2)+ROWS(B$2:B2)*8-8)

That's look great, thank you.

I've no idea how the formula works that out, but it does

 

[Fluff]

You're welcome & thanks for the feedback.