Counting the groups

[Nykyta]

I need to solve the nnext issue (in worksheet or VBA - never mind). In the next column, I have something as:


group

group

blank

group

group

group

blank

group

group

blank

group

group

group

group

blank

group

blank

group

blank

group

blank

group

group

group

blank


... etc ...
What is the best way to find how many groups I have there?
a) groups with 1 "group" repeating;

b) groups with 2 "group" repeating one after another;

c) groups with 3 "group" repeating one after another;

d) groups with 4 "group" repeating one after another;

e) groups with 5 "group" repeating one after another; etc.

I hope that my question is clear enoug. Thanks in advance! Nyk

 

[Nykyta]

Oeldere, I have no ten hands.
Your solution is something I am dealing with already (many cells, many formulas...). When I wrote that Mike solution is the real / needed one, that should be the hit. In the new Excel file you can check-out the code inside Visual Basic Editor and understand what I am talking about.

I planed to answer to each single user in one post but you were so fast and little bit nervous! Thanks a lot for your time and suggestion.

 

[Nykyta]

Thanks Mick.

If you checkout the solution of MARK858, you’ll see the simplest solution for my problem. There are new excel sample file uploaded (2^nd page of this thread). Your code is changing the worksheet and that are not good for this case.

Thanks again for your reply.

 

[Nykyta]

Thanks Aladin Akyurek.

As I can see so far, you are counting areas [Ctrl + Shift + Enter] according given condition. That’s also work of course but Mikes solution were the best. I have 12 worksheets and the final one “Analyzes” where I collected all data for further work. All done through VBA so few lines of Mike code a perfect. Your cell-formulas should be in the each of that sheets so… a lot of work saved.

Thanks again for your reply.

 

[Nykyta]

Oeldere, as you can see in my sample sheet, I am already using something like that you posted in addition of your solution. That is the main goal.