how to count each number/letter individually and in groups of:

0

I ve a system that I follow to find out how many times each number/letter showed up. I need to learn how to count each number/letter individually, and in groups of 3, 4, 5, 6, 7, 8, 9, 10.

I d like to learn how to program the excel to do it. If you can help, teach me how to do it. Take a look at the lines I ve til now.

1 2 3 7 8 C F H I J

1 2 3 11 13 A B D E J

1 2 5 6 9 13 B C G H I J

1 2 5 7 8 13 A B C D I J

1 2 5 8 9 13 15 A B C F G H J

1 3 4 10 11 B C G H I

1 3 6 9 13 14 C D E F G J

1 3 7 9 10 12 B D E F G H

1 3 13 14 15 A B C F H

1 4 5 7 10 D E G I J

1 4 7 8 9 10 A B C E G J

1 5 6 8 B D E J

1 5 6 10 13 14 15 A B E F G I J

1 5 7 10 12 C E G H I

1 5 8 13 14 15 A B D E F I

1 7 8 9 10 11 15 A D E F G I J

1 9 12 13 A B C D

2 3 5 6 7 9 10 14 15 A B C D E F G H J  

2 3 8 10 11 15 A B D F I J

2 4 5 15 B E F G

2 4 7 11 14 15 B C E F I J

2 5 9 14 B C E J

2 6 7 8 9 13 A D F G I J

2 7 9 10 12 14 B C D F G J

2 9 10 12 14 A C E F J

2 9 11 12 13 15 A D E F G J  

3 4 5 6 7 11 14 A B C D F G I

3 4 8 10 11 13 14 15 A C E F G H I J

3 5 7 10 11 13 15 A B C D E G H

3 5 8 12 14 B C F H J

4 5 6 13 15 A C G H I

4 5 7 8 12 15 B D E F G J

4 5 8 9 A D G J

4 5 8 10 11 13 14 B C E F H I J

4 8 9 11 13 B C E F G

6 7 8 9 10 15 A B E F H J 

Answer
Discuss

Discussion

What do you mean by "in groups of 3, 4, 5, 6, 7, 8, 9, 10"?
don (rep: 1247) Aug 27, '16 at 10:27 pm
I d like to make a chart with how many times 3 to 10 number/letters matched on each line. 
Ed L Aug 28, '16 at 5:46 am
Upload a sample spreadsheet with sample data and a sample result that you want. I'm still a little confused but have you tried using PivotTables?
don (rep: 1247) Aug 29, '16 at 3:04 pm
I m still learning about pivot tables. Can u teach me how to do it?
Ed L Aug 31, '16 at 7:17 pm
I still need a sample file showing the data how it is now and what you want it to look like. As I said in the last comment:
"Upload a sample spreadsheet with sample data and a sample result that you want."
don (rep: 1247) Sep 1, '16 at 4:23 pm
Add to Discussion


Answer the Question

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