I have 49 records as follows
1--11 17 23 38 39 47
2--12 18 24 39 40 48
3--13 19 25 40 41 49
4--1 14 20 26 41 42
5--2 15 21 27 42 43
6--3 16 22 28 43 44
7--4 17 23 29 44 45
8--5 18 24 30 45 46
9--6 19 25 31 46 47
10--7 20 26 32 47 48
11--8 21 27 33 48 49
12--1 9 22 28 34 49
13--1 2 10 23 29 35
14--2 3 11 24 30 36
15--3 4 12 25 31 37
16--4 5 13 26 32 38
17--5 6 14 27 33 39
18--6 7 15 28 34 40
19--7 8 16 29 35 41
20--8 9 17 30 36 42
21--9 10 18 31 37 43
22--10 11 19 32 38 44
23--11 12 20 33 39 45
24--12 13 21 34 40 46
25--13 14 22 35 41 47
26--14 15 23 36 42 48
27--15 16 24 37 43 49
28--1 16 17 25 38 44
29--2 17 18 26 39 45
30--3 18 19 27 40 46
31--4 19 20 28 41 47
32--5 20 21 29 42 48
33--6 21 22 30 43 49
34--1 7 22 23 31 44
35--2 8 23 24 32 45
36--3 9 24 25 33 46
37--4 10 25 26 34 47
38--5 11 26 27 35 48
39--6 12 27 28 36 49
40--1 7 13 28 29 37
41--2 8 14 29 30 38
42--3 9 15 30 31 39
43--4 10 16 31 32 40
44--5 11 17 32 33 41
45--6 12 18 33 34 42
46--7 13 19 34 35 43
47--8 14 20 35 36 44
48--9 15 21 36 37 45
49--10 16 22 37 38 46
I would want an Excel macro to pick all possible five records. It should compare the numbers in those five records and only give results of all numbers appearing more than once and those numbers when counted should be exact eight.
Example
12--1 9 22 28 34 49
20--8 9 17 30 36 42
32--5 20 21 29 42 48
33--6 21 22 30 43 49
44--5 11 17 32 33 41
If you pick record 12,,20,32,33,and 44 the following numbers appear more that once
49,42,30, 22,21,17,9,5 and they are 8
But if you pick records 9,14,27,36,44
9--6 19 25 31 46 47
14--2 3 11 24 30 36
27--15 16 24 37 43 49
36--3 9 24 25 33 46
44--5 11 17 32 33 41
The following numbers appear more than once 24,46,33,3,25,11 though when counted they are less than 8 and therefore not required.
You kind assistance is highly appreciated
Thank you
1--11 17 23 38 39 47
2--12 18 24 39 40 48
3--13 19 25 40 41 49
4--1 14 20 26 41 42
5--2 15 21 27 42 43
6--3 16 22 28 43 44
7--4 17 23 29 44 45
8--5 18 24 30 45 46
9--6 19 25 31 46 47
10--7 20 26 32 47 48
11--8 21 27 33 48 49
12--1 9 22 28 34 49
13--1 2 10 23 29 35
14--2 3 11 24 30 36
15--3 4 12 25 31 37
16--4 5 13 26 32 38
17--5 6 14 27 33 39
18--6 7 15 28 34 40
19--7 8 16 29 35 41
20--8 9 17 30 36 42
21--9 10 18 31 37 43
22--10 11 19 32 38 44
23--11 12 20 33 39 45
24--12 13 21 34 40 46
25--13 14 22 35 41 47
26--14 15 23 36 42 48
27--15 16 24 37 43 49
28--1 16 17 25 38 44
29--2 17 18 26 39 45
30--3 18 19 27 40 46
31--4 19 20 28 41 47
32--5 20 21 29 42 48
33--6 21 22 30 43 49
34--1 7 22 23 31 44
35--2 8 23 24 32 45
36--3 9 24 25 33 46
37--4 10 25 26 34 47
38--5 11 26 27 35 48
39--6 12 27 28 36 49
40--1 7 13 28 29 37
41--2 8 14 29 30 38
42--3 9 15 30 31 39
43--4 10 16 31 32 40
44--5 11 17 32 33 41
45--6 12 18 33 34 42
46--7 13 19 34 35 43
47--8 14 20 35 36 44
48--9 15 21 36 37 45
49--10 16 22 37 38 46
I would want an Excel macro to pick all possible five records. It should compare the numbers in those five records and only give results of all numbers appearing more than once and those numbers when counted should be exact eight.
Example
12--1 9 22 28 34 49
20--8 9 17 30 36 42
32--5 20 21 29 42 48
33--6 21 22 30 43 49
44--5 11 17 32 33 41
If you pick record 12,,20,32,33,and 44 the following numbers appear more that once
49,42,30, 22,21,17,9,5 and they are 8
But if you pick records 9,14,27,36,44
9--6 19 25 31 46 47
14--2 3 11 24 30 36
27--15 16 24 37 43 49
36--3 9 24 25 33 46
44--5 11 17 32 33 41
The following numbers appear more than once 24,46,33,3,25,11 though when counted they are less than 8 and therefore not required.
You kind assistance is highly appreciated
Thank you
