I need to find a way to group test results together. The best way to explain what I need is to use the lottery as an example.
Each drawing date six numbers are chosen. I want to know how many times unique pairs (2 numbers), triads (3 numbers), quads (4 numbers), quints (5 numbers) have occurred.
9/12/2001 16-24-30-31-36-49
9/15/2001 7-16-17-28-43-45
9/19/2001 8-12-13-31-42-46
9/22/2001 19-28-31-41-44-47
9/26/2001 1-2-11-14-42-44
9/29/2001 2-24-27-38-40-41
10/3/2001 6-14-28-37-39-48
10/6/2001 5-17-20-34-41-47
10/10/2001 6-10-11-29-34-49
10/13/2001 7-11-12-28-45-46
10/17/2001 5-9-13-14-15-22
10/20/2001 16-18-19-38-41-49
10/24/2001 3-4-12-16-20-23
10/27/2001 3-8-11-17-27-28
10/31/2001 2-5-15-19-41-43
11/3/2001 7-10-35-37-42-45
11/7/2001 7-14-19-20-24-45
11/10/2001 1-7-35-40-43-46
11/14/2001 7-10-15-22-23-36
11/17/2001 13-20-28-34-35-46
11/21/2001 6-26-28-31-34-46
11/24/2001 3-13-14-29-37-45
11/28/2001 22-23-27-31-42-44
12/1/2001 5-6-9-19-32-47
12/5/2001 11-20-26-30-34-36
12/8/2001 5-18-27-30-34-45
12/12/2001 2-14-23-32-40-45
12/15/2001 4-7-13-27-37-49
12/19/2001 2-5-27-40-46-49
12/22/2001 1-19-31-35-36-41
Results Needed:
HITS COMPANION PAIRS
4......07-45, 19-41
3......02-40, 14-45, 20-34, 28-46
2......01-35, 02-05, 02-14, 02-27, 02-41, 05-09, 05-15, 05-19, 05-27,
05-34, 05-41, 05-47, 06-28, 06-34, 07-10, 07-28, 07-35, 07-37,
07-43, 07-46, 11-28, 11-34, 12-46, 13-14, 13-37, 13-46, 14-37,
15-22, 16-49, 17-28, 19-31, 19-47, 22-23, 26-34, 27-40, 27-49,
28-31, 28-34, 28-45, 30-34, 30-36, 31-36, 31-41, 31-42, 31-44,
31-46, 34-46, 35-46, 37-45,
HITS COMPANION TRIADS
2......02-27-40, 07-28-45, 19-31-41, 28-34-46
I need to find a way to group test results together. The best way to explain what I need is to use the lottery as an example.
Each drawing date six numbers are chosen. I want to know how many times unique pairs (2 numbers), triads (3 numbers), quads (4 numbers), quints (5 numbers) have occurred.
9/12/2001 16-24-30-31-36-49
9/15/2001 7-16-17-28-43-45
9/19/2001 8-12-13-31-42-46
9/22/2001 19-28-31-41-44-47
9/26/2001 1-2-11-14-42-44
9/29/2001 2-24-27-38-40-41
10/3/2001 6-14-28-37-39-48
10/6/2001 5-17-20-34-41-47
10/10/2001 6-10-11-29-34-49
10/13/2001 7-11-12-28-45-46
10/17/2001 5-9-13-14-15-22
10/20/2001 16-18-19-38-41-49
10/24/2001 3-4-12-16-20-23
10/27/2001 3-8-11-17-27-28
10/31/2001 2-5-15-19-41-43
11/3/2001 7-10-35-37-42-45
11/7/2001 7-14-19-20-24-45
11/10/2001 1-7-35-40-43-46
11/14/2001 7-10-15-22-23-36
11/17/2001 13-20-28-34-35-46
11/21/2001 6-26-28-31-34-46
11/24/2001 3-13-14-29-37-45
11/28/2001 22-23-27-31-42-44
12/1/2001 5-6-9-19-32-47
12/5/2001 11-20-26-30-34-36
12/8/2001 5-18-27-30-34-45
12/12/2001 2-14-23-32-40-45
12/15/2001 4-7-13-27-37-49
12/19/2001 2-5-27-40-46-49
12/22/2001 1-19-31-35-36-41
Results Needed:
HITS COMPANION PAIRS
4......07-45, 19-41
3......02-40, 14-45, 20-34, 28-46
2......01-35, 02-05, 02-14, 02-27, 02-41, 05-09, 05-15, 05-19, 05-27,
05-34, 05-41, 05-47, 06-28, 06-34, 07-10, 07-28, 07-35, 07-37,
07-43, 07-46, 11-28, 11-34, 12-46, 13-14, 13-37, 13-46, 14-37,
15-22, 16-49, 17-28, 19-31, 19-47, 22-23, 26-34, 27-40, 27-49,
28-31, 28-34, 28-45, 30-34, 30-36, 31-36, 31-41, 31-42, 31-44,
31-46, 34-46, 35-46, 37-45,
HITS COMPANION TRIADS
2......02-27-40, 07-28-45, 19-31-41, 28-34-46