Need to know grouped count.

  • Thread starter Thread starter Madiya
  • Start date Start date
M

Madiya

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
 
Hi
No idea what you want. Can you show what you want to see from the
example numbers you give?
regards
Paul
 
Hi
No idea what you want. Can you show what you want to see from the
example numbers you give?
regards
Paul





- Show quoted text -
Click to expand...

Paul,
Thanks for taking intrest in my problem.
My data is in Col A (Series).
I want to count how many group is there in continuous series.
Now for e.g., say how many 1 is there in continuous series.
Answer is required in Col 2 (Group), as already shown.
In this case, 1st continuous series counts 9, so I want 9 in each row
against 1.
Then 1 changes to 2, so count starts again.
In next line 2 changes to 1, so count starts again.
This time there is 1 in four continuous rows. So I want 4 in each row
against them.

Hope I have explained properly.

Regards,
Madiya
 
Back
Top