Hi all. I prepared a small example database but it seems that I'm not allowed to post an attachment so I'll try and explain my dilemma by using one of the above tables.
<tbody>
</tbody>
This is a typical example of winning Lotto results over 7 draws of a 6-pick, 40-number lottery.
(The real database contains about 1500 draws).
I'm trying to find out if any of the 1500 results have ever been duplicated.
For example, rows 1,3 and 6 contain the same numbers.
But they're in different numerical order, as is almost certain to be the case in real life.
Could a formula recognize the duplicated 6 numbers even though their order is different?
A | B | C | D | E | F | G etc | etc | etc | etc |
39 | 6 | 23 | 34 | 2 | 7 | ||||
26 | 8 | 3 | 35 | 18 | 22 | ||||
7 | 23 | 2 | 39 | 6 | 34 | ||||
3 | 16 | 39 | 40 | 6 | 12 | ||||
22 | 17 | 9 | 27 | 10 | 2 | ||||
23 | 34 | 6 | 2 | 7 | 39 |
<tbody>
</tbody>
This is a typical example of winning Lotto results over 7 draws of a 6-pick, 40-number lottery.
(The real database contains about 1500 draws).
I'm trying to find out if any of the 1500 results have ever been duplicated.
For example, rows 1,3 and 6 contain the same numbers.
But they're in different numerical order, as is almost certain to be the case in real life.
Could a formula recognize the duplicated 6 numbers even though their order is different?