I need to know the max nos grouped together (second col). My list is
as below.
series group
2 1
3 1
2 3
2 3
2 3
1 9
1 9
1 9
1 9
1 9
1 9
1 9
1 9
1 9
2 1
1 4
1 4
1 4
1 4
I need a formula that gives me group count. Subtotal will not work coz
I want the count in each row. Whenever there is a change in the col A,
group count starts again.

Is there any way to do this by VBA (formula is more preffered).

Regards,
Madiya