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...
I think this was posted a week ago. Here's my take:
=LET(uArr,UNIQUE(arr),XMATCH(arr,uArr)-1)