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

 

[ranman256]

Why binary? humans think in 10s.
and fill what boxes? where's the source #? , and fill what target box from the sourc#?

 

[tezza]

Why binary? humans think in 10s.
and fill what boxes? where's the source #? , and fill what target box from the sourc#?

Number	Binary	Box 5	Box 4	Box 3	Box 2	Box 1
1	00001	0	0	0	0	1
2	00010	0	0	0	1	0
3	00011	0	0	0	1	1
4	00100	0	0	1	0	0
5	00101	0	0	1	0	1
6	00110	0	0	1	1	0
7	00111	0	0	1	1	1
8	01000	0	1	0	0	0
9	01001	0	1	0	0	1
10	01010	0	1	0	1	0
If there is a 1 in columns Box D to Box H then the number in Col B belongs in that box
So 7 has a 1 in Box 1, 2 & 3 so that's where 7 should appear.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2		Number	Binary	Box 5	Box 4	Box 3	Box 2	Box 1
3		1	00001	0	0	0	0	1
4		2	00010	0	0	0	1	0
5		3	00011	0	0	0	1	1
6		4	00100	0	0	1	0	0
7		5	00101	0	0	1	0	1
8		6	00110	0	0	1	1	0
9		7	00111	0	0	1	1	1
10		8	01000	0	1	0	0	0
11		9	01001	0	1	0	0	1
12		10	01010	0	1	0	1	0
Data

Cell Formulas
Range	Formula
C3:C12	C3	=DEC2BIN(B3,5)
D3:H12	D3	=MID(DEC2BIN($B3,5),COLUMNS($D3:D3),1)

 

[tezza]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2		Number	Binary	Box 5	Box 4	Box 3	Box 2	Box 1
3		1	00001	0	0	0	0	1
4		2	00010	0	0	0	1	0
5		3	00011	0	0	0	1	1
6		4	00100	0	0	1	0	0
7		5	00101	0	0	1	0	1
8		6	00110	0	0	1	1	0
9		7	00111	0	0	1	1	1
10		8	01000	0	1	0	0	0
11		9	01001	0	1	0	0	1
12		10	01010	0	1	0	1	0
Data

Cell Formulas
Range	Formula
C3:C12	C3	=DEC2BIN(B3,5)
D3:H12	D3	=MID(DEC2BIN($B3,5),COLUMNS($D3:D3),1)

Hi Fluff,

What I'm looking for is to populate boxes like in the first post if possible.

The above was meant to hopefully provide better information.

 

[Fluff]

Which boxes? You need to provide some expected results.

 

[tezza]

Which boxes? You need to provide some expected results.

I've started inputting numbers into the boxes in the original post, up to number 8.

 

[Fluff]

That may make sense to you, but I have no idea which boxes should get filled or when.

 

[tezza]

That may make sense to you, but I have no idea which boxes should get filled or when.

Fair point. The output should be:

	1	3	5	7	9	11	13	15			2	3	6	7	10	11	14	15			4	5	6	7	12	13	14	15
card 1	17	19	21	23	25	27	29	31		card 2	18	19	22	23	26	27	30	31		card 3	20	21	22	23	28	29	30	31
	33	35	37	39	41	43	45	47			34	35	38	39	42	43	46	47			36	37	38	39	44	45	46	47
	49	51	53	55	57	59	61	63			50	51	54	55	58	59	62	63			52	53	54	55	60	61	62	63
	8	9	10	11	12	13	14	15			16	17	18	19	20	21	22	23			32	33	34	35	36	37	38	39
card 4	24	25	26	27	28	29	30	31		card 5	24	25	26	27	28	29	30	31		card 6	40	41	42	43	44	45	46	47
	40	41	42	43	44	45	46	47			48	49	50	51	52	53	54	55			48	49	50	51	52	53	54	55
	56	57	58	59	60	61	62	63			56	57	58	59	60	61	62	63			56	57	58	59	60	61	62	63

If you look at the binary number for 43 it will be 101011 which places 43 in boxes 6, 4, 2, 1 - relevant to where the 1's are.

 

[Fluff]

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)