Forum Discussion
Increment a value based upon adjacent cell, but count restarts when number occurs again
I'm going to keep this simple, but basically, I have a list of numbers that differ (0,0,1,2,0,0) that need to have a number incremented based on how many identical codes are in the list and restart w...
I may be slow, but I'm not following your example. Could you annotate it for us, thus explaining in just a bit more detail, where the count is incrementing (and why) and where it's restarting (and why). I'm sure it's entirely clear to you, but having the algorithm totally clear is the first step in seeing how Excel can do it.... Thanks
mathetes , on this sample - we have 3 sequential zeroes and count them one by one till another number appears. When we start numbering this number. If sequence of previous number appears (let say zeroes again) we start numbering of this sequence from scratch.