I'm not for sure if I could use a formula but would rather have a macro. Let's say I have a column with cell values of either an A, B, or C sorted asending. I would like to count the A's for "x" number and repeat until a change in A. Then count B's for "x" number and repeat, then C's. Something like this. The "x" for each will vary form time to time but I can change the "x" value within the macro.
Any input would be very helpful. Thank you.
A's in one column, numbers in another
A:1
A:2
A:3
A:1
A:2
A:3
A:1
Then B's
B:1
B:2
B:1
B:2
B:1
B:2
B:1
Then C's
C:1
C:2
C:3
C:4
C:5
C:1
C:2
C:3
C:4
C:5
C:1
C:2
Any input would be very helpful. Thank you.
A's in one column, numbers in another
A:1
A:2
A:3
A:1
A:2
A:3
A:1
Then B's
B:1
B:2
B:1
B:2
B:1
B:2
B:1
Then C's
C:1
C:2
C:3
C:4
C:5
C:1
C:2
C:3
C:4
C:5
C:1
C:2