GRID 3x3, row, column, total must be 14

[motilulla]

Hello,

Is it possible to create all possible Grids 3x3 which rows and column total must be 14 using all numbers are in column B, C, D

Apart of creating all possible Grids could be having random option too.

Example below showing 4 examples not necessary show the total of rows and columns it is shown just for example

Book1
	A	B	C	D	E	F	G	H	I	J
1		Choice 1	Choice 2	Choice 3
2		0	5	9
3		0	6	8
4		0	7	7
5		0	8	6		0	5	9	14
6		0	9	5		6	4	4	14
7		1	4	9		8	5	1	14
8		1	5	8		14	14	14
9		1	6	7
10		1	7	6		6	5	3	14
11		1	8	5		3	3	8	14
12		1	9	4		5	6	3	14
13		2	3	9		14	14	14
14		2	4	8
15		2	5	7		9	2	3	14
16		2	6	6		3	5	6	14
17		2	7	5		2	7	5	14
18		2	8	4		14	14	14
19		2	9	3
20		3	2	9		5	7	2	14
21		3	3	8		3	4	7	14
22		3	4	7		6	3	5	14
23		3	5	6		14	14	14
24		3	6	5
25		3	7	4
26		3	8	3
27		3	9	2
28		4	1	9
29		4	2	8
30		4	3	7
31		4	4	6
32		4	5	5
33		4	6	4
34		4	7	3
35		4	8	2
36		4	9	1
37		5	0	9
38		5	1	8
39		5	2	7
40		5	3	6
41		5	4	5
42		5	5	4
43		5	6	3
44		5	7	2
45		5	8	1
46		5	9	0
47		6	0	8
48		6	1	7
49		6	2	6
50		6	3	5
51		6	4	4
52		6	5	3
53		6	6	2
54		6	7	1
55		6	8	0
56		7	0	7
57		7	1	6
58		7	2	5
59		7	3	4
60		7	4	3
61		7	5	2
62		7	6	1
63		7	7	0
64		8	0	6
65		8	1	5
66		8	2	4
67		8	3	3
68		8	4	2
69		8	5	1
70		8	6	0
71		9	0	5
72		9	1	4
73		9	2	3
74		9	3	2
75		9	4	1
76		9	5	0
77
78
79
80
81
Sheet2

Thank you all
Excel 2000
Regards,
Moti

 

[thisoldman]

I suppose you could do it with VBA. May I ask why?

 

[motilulla]

I suppose you could do it with VBA. May I ask why?

Hello thisoldman,

I want total for the row or column 14; diagonals could be any no matter.

Off course need VBA solution to create all possible squares, and if get options to create random will be the great.

I found the link below but does not meet with my requirement
https://www.mrexcel.com/forum/excel-questions/1046773-3-x-3-grid-2.html#post5028238

Thank for looking my request

Kind Regards,
Moti

 

[thisoldman]

When you find one square, you actually find eight solutions.

Book1
	J	K	L	M	N	O	P	Q	R
2	A	9	3	2		2	3	9	E
3		2	5	7		7	5	2
4		3	6	5		5	6	3
5
6	B	3	2	9		5	7	2	F
7		6	5	3		6	5	3
8		5	7	2		3	2	9
9
10	C	5	6	3		3	6	5	G
11		7	5	2		2	5	7
12		2	3	9		9	3	2
13
14	D	2	7	5		9	2	3	H
15		3	5	6		3	5	6
16		9	2	3		2	7	5
17
Sheet1

E is a mirror image of A. The squares are then rotated clockwise as you go down each column. It should be easy to see that B and H are mirror images, as are C and G, and D and F.

 

[motilulla]

When you find one square, you actually find eight solutions.

	J	K	L	M	N	O	P	Q	R
2	A	9	3	2		2	3	9	E
3		2	5	7		7	5	2
4		3	6	5		5	6	3
5
6	B	3	2	9		5	7	2	F
7		6	5	3		6	5	3
8		5	7	2		3	2	9
9
10	C	5	6	3		3	6	5	G
11		7	5	2		2	5	7
12		2	3	9		9	3	2
13
14	D	2	7	5		9	2	3	H
15		3	5	6		3	5	6
16		9	2	3		2	7	5
17

<tbody>
</tbody>

Sheet1​

E is a mirror image of A. The squares are then rotated clockwise as you go down each column. It should be easy to see that B and H are mirror images, as are C and G, and D and F.

thisoldman, but how could be done these by formula or with VBA

Regards
Moti

 

[thisoldman]

I'm thinking about it and getting lost. I don't think I can solve it.

These are the seventy-five distinct permutations of three non-negative integers that add to 14 (I don't think I missed any). The first triplet you place in the grid can appear in any of six positions. The choice of the second triplet is limited—it must be compatible with the one already in place. There are five possible positions for this second triplet. ...

These are the fifteen distinct triplet combinations that add to 14. I've listed the number of permutations for each combination.

				Permutations
0	5	9		6
0	6	8		6
0	7	7		3
1	4	9		6
1	5	8		6
1	6	7		6
2	3	9		6
2	4	8		6
2	5	7		6
2	6	6		3
3	3	8		3
3	4	7		6
3	5	6		6
4	4	6		3
4	5	5		3

<tbody>
</tbody>

I was wrong in my previous post, writing that finding one solution gives you eight solutions. Some solutions with repeated digits only give four distinct variations:

4	4	6		6	4	4
4	6	4		4	6	4
6	4	4		4	4	6
4	6	4		4	6	4
6	4	4		4	4	6
4	4	6		6	4	4

<tbody>
</tbody>

 

[motilulla]

I'm thinking about it and getting lost. I don't think I can solve it.

Hello thisoldman, thank you for your efforts

I think it's difficult to make all manually, may some one can understand the idea, and give VBA solutions

Regards
Moti

 

[motilulla]

Please do have any solution of this tricky puzzle ?

Thank you

Regards

 

[motilulla]

Bump

 

[motilulla]

Hello everyone,

Search into MrExcel there is no VBA solution for 3x3 square which rows and column sums = 14
Goggled there is no such VBA in the entire goggle.
You tube also doesn't found any video regarding my request.

Please need help

Regards,
Moti