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

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: 1989) 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: 1989) 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: 1989) 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