I m doing a statistical work on a lottery, and what I need is to make a checker chart on excel that it shows how many matches I got on each line. I ve 12 lines of 15 characters on each line. After each result, a new line is added.
Its a 15 characters from 01 to 15 and the letters A to J.
I need to learn how to make this checker, so I dont need to do it by hand on the paper.
And I also need to count the number of occurences of each character on the selected lines. I need to count all the 15 characters on all lines and also separately on selected lines. Take a look on the lines.
2 4 5 7 9 10 12 14 b d e f g h j
1 2 4 6 7 11 13 14 15 a c f g i j
2 4 7 9 10 13 15 a b c d e g h i
3 4 7 9 10 11 12 13 14 15 d f g i j
1 2 3 6 9 10 13 14 15 b d e f g i
3 4 5 11 12 13 14 b c d e g h i j
1 4 5 7 8 9 10 11 14 a d e f g h
1 2 3 5 6 7 9 10 12 13 c d f g i
1 3 4 5 6 7 8 9 10 12 15 b d f h
1 3 5 6 8 9 10 11 15 a f g h i j
3 4 6 7 10 11 12 14 a c d g h i j
3 5 6 8 10 11 12 13 14 15 a c f g h