Jan 04 2020 12:48 PM
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 when the number is counted again, the trouble is that this list won't be ordered numerically, below is an example of what I am looking to do:
A1 B1
0 1
0 2
0 3
1 1
0 1
0 2
2 1
3 2
2 1
2 2
0 1
Essentially I need a function that can the count and restart when the same number is counted again, in the adjacent column.
My apologies if the question is relatively easy, but excel is not my strong suit. Thank you.
Jan 04 2020 04:27 PM
Jan 04 2020 04:52 PM
@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.
Jan 04 2020 05:02 PM