Generate random lotto numbers in groups

[Blackballexpress]

Hi all,

Can anyone help me please:

I am trying to generate random lotto in 8 groups of 8 rows each.

The aim is to have 8 groups with the following criteria.

• numbers appears only once per group;
• if 16 & 27 appears together in the same row in group 1, it does not appear together again in any row of the other groups;

Optional

• There should be no 4 number combinations in the rows that was previously selected in draws.

I am currently using the following formula:
Sheet = Calculations
In the culumns I have:
All formulas is dragged down
A =RAND()
B =RANK($B3;$B$3:$B$54)+COUNTIF(C$2:C2;C2)-1

	B	C	D	E	F	G	H	I	J
1	Rand	Unique Rank	Ball Number	1	2	3	4	5	6
2	0,102220611	51	1	7	8	9	10	11	12
3	0,20398705	44	2	13	14	15	16	17	18
4	0,477662672	32	3	19	20	21	22	23	24
5	0,552747222	27	4	25	26	27	28	29	30
6	0,506884168	30	5	31	32	33	34	35	36
7	0,384547559	36	6	37	38	39	40	41	42
8	0,752876494	16	7	43	44	45	46	47	48
9	0,204919304	43	8
10	0,347860702	37	9
11	0,991859907	2	10
12	0,548126033	28	11
13	0,453121519	33	12
14	0,197456759	45	13
15	0,708482563	20	14
16	0,115405	51	15
17	0,259358455	40	16
18	0,175012773	47	17
19	0,813651919	12	18
20	0,127723026	49	19
21	0,91282479	8	20
22	0,43280353	34	21
23	0,117688382	50	22
24	0,950455468	6	23
25	0,718628697	19	24
26	0,835158982	10	25
27	0,960684958	3	26
28	0,248949597	41	27
29	0,911179321	9	28
30	0,61501937	24	29
31	0,405203367	35	30
32	0,960485786	4	31
33	0,478130291	31	32
34	0,609704978	25	33
35	0,653939378	22	34
36	0,689407296	21	35
37	0,242265148	42	36
38	0,957641772	5	37
39	0,770038372	15	38
40	0,738311875	18	39
41	0,073065667	52	40
42	0,617414067	23	41
43	0,174912359	48	42
44	0,532459304	29	43
45	0,271544494	39	44
46	0,790350128	13	45
47	0,771215945	14	46
48	0,175958643	46	47
49	0,948371839	7	48
50	0,343735137	38	49
51	0,604571472	26	50
52	0,834753212	11	51
53	0,738643848	17	52

<tbody>
</tbody><colgroup><col><col><col><col><col span="6"></colgroup>

Sheet = Draws
In the culumns I have:
All formulas is dragged down
B =VLOOKUP(Calculations!E2;Calculations!$C$3:$D$54;2;FALSE)
C =VLOOKUP(Calculations!F2;Calculations!$C$3:$D$54;2;FALSE)
D =VLOOKUP(Calculations!G2;Calculations!$C$3:$D$54;2;FALSE)
E =VLOOKUP(Calculations!H2;Calculations!$C$3:$D$54;2;FALSE)
F =VLOOKUP(Calculations!I2;Calculations!$C$3:$D$54;2;FALSE)
G =VLOOKUP(Calculations!J2;Calculations!$C$3:$D$54;2;FALSE)

	B	C	B	E	F	G
1	1	10	26	31	37	23
2	48	20	28	25	51	18
3	45	46	38	7	52	39
4	24	14	35	34	41	29
5	33	50	4	11	43	5
6	32	3	12	21	30	6
7	9	49	44	16	27	36
8	8	2	13	47	17	42

<tbody>
</tbody><colgroup><col span="8"></colgroup>

Thank you very much!!!!!!