Hi all I have a list of 10000 numbers in a row.
the numbers are all listed in the format 3:6:2:8
made up of number 1 to 10.
what is the easiest way to find out which are the most common 4 numbers to make up a combanation?
Also what are the most common 3 numbers that are part of the four number combination?
here is a small exsample of the numbers.
A1
<colgroup><col style="width: 48pt;" width="64"> <tbody>
</tbody>
the numbers are all listed in the format 3:6:2:8
made up of number 1 to 10.
what is the easiest way to find out which are the most common 4 numbers to make up a combanation?
Also what are the most common 3 numbers that are part of the four number combination?
here is a small exsample of the numbers.
A1
5:3:10:4 |
7:3:2:5 |
5:7:8:4 |
3:1:4:8 |
8:1:6:5 |
6:3:5:7 |
3:5:4:8 |
5:7:1:6 |
5:3:10:2 |
5:8:4:1 |
4:1:3:6 |
5:3:1:7 |
5:4:6:8 |
1:3:8:7 |
3:1:8:5 |
3:8:6:7 |
10:5:8:1 |
7:2:5:1 |
6:4:2:3 |
6:3:4:1 |
1:3:8:4 |
3:8:6:5 |
8:6:3:1 |
2:3:8:5 |
6:5:7:8 |
6:3:9:4 |
8:2:1:6 |
7:8:1:3 |
8:7:6:2 any help much appreciated |
<colgroup><col style="width: 48pt;" width="64"> <tbody>
</tbody>