# Help me to do this

0

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

### Discussion

This forum is about Teaching Excel. Please amend the title of your question to make it relate to the subject of your question, not its nature.
It seems that you have three questions. The way this forum works, we can handle one question per thread. As a rule, I don't do follow-up questions, but it is hard to say what constitutes a follow-up at the beginning of a thread.
Your first question seems to be embedded in these sentences of yours. "Its 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." Is it true that you need one line at any one time? Or do you need 12 lines each time? And, of course, how do you make the lines on paper?
Variatus (rep: 1318) Oct 29, '17 at 1:04 am

0

Hi