Increment counter based on change in cell value

user_5398800 0
Viewed 4241

I'm trying to put a formula that can iterate the count of windows. The window should increment on a change in binary. Ideally something like this. Given columns id and binary, window should increment as values in binary changes between 0 and 1.

Something like this:

enter image description here

Is there a formula that can solution this, or is VBA the way?

rows vba excel
1 Answers
Related