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...
=COUNT(UNIQUE($A$1:A1))-1=BYROW(A1:A10,LAMBDA(row,COUNT(UNIQUE(A1:row))-1))With Office 365 or Excel 2021 or Excel for the web you can try these formulas.