how to write sequential numbers for the first occurring number

[dmcgov]

so i have two ranges, a Before and an After

basically i want to write the first occurring integer and put a 1 in the after column. how can this be done?

WritingSequentialNumbers.png

[dmcgov]

so i used this formula in my helper column

=IF(INT(U8)=0,0,IF(INT(U8)=INT(U7),0,1))

that fixed the issue