Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

Answer
Discuss

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: 4889) Oct 29, '17 at 1:04 am
Add to Discussion

Answers

0

Hi 

Could anyone please help me to draw a Ring Bell Diagramm from my data?

Discuss

Discussion

I did Z Score and Normal Distribution but, it dose not make a Ring Bell Diagramm!!
Michael Wolf Oct 29, '17 at 5:40 am
You need to ask a separate question for this and not ask it here in someone else's question. (I will remove this post once you see it.)
don (rep: 1989) Oct 29, '17 at 2:10 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login