guhl_yarden
New Member
- Joined
- May 3, 2018
- Messages
- 2
Hi All,
Could please someone help me with some formula? It drives me crazy since days/weeks.
I would like to do the following but dont even have an idea how to describe it :D
Count "A" until there is "B". Stop countung "A" but start count "B". If there is "A" again start over but add 1 to the last "A" value
Hope its clear :D
Maybe this picture helps more than 1000 words.
Im using Excel 2016 but have uploaded on google drive as well in the case the picture gets lost in the ether:
https://docs.google.com/spreadsheets/d/1ZCiNsD6bYOnp74HUy7V1ZLZRz9QZl_nt3l59PO83czs/edit?usp=sharing
Thanks in advance everyone
Could please someone help me with some formula? It drives me crazy since days/weeks.
I would like to do the following but dont even have an idea how to describe it :D
Count "A" until there is "B". Stop countung "A" but start count "B". If there is "A" again start over but add 1 to the last "A" value

Maybe this picture helps more than 1000 words.

Im using Excel 2016 but have uploaded on google drive as well in the case the picture gets lost in the ether:
https://docs.google.com/spreadsheets/d/1ZCiNsD6bYOnp74HUy7V1ZLZRz9QZl_nt3l59PO83czs/edit?usp=sharing
Thanks in advance everyone
