Forum Discussion
How to restart numbering of ID column from 0
I have an ID column with IDs as such: 1900 1900 2345 2345 3209 3209 3209 4325 4325 4325 I would like to restart this numbering from 0. For example, 1900 would be 0 and 2345 would b...
If you work with an older version e.g. Excel 2013 you can use a helper formula which is in cell C2 in the example:
=IF(B2=B1,C1,C1+1)And this is the formula in cell D2:
=C2-1Both formulas can be filled down as required.