I have this data where I want to identify all the sequential numbers across different rows and give them a unique reference For eg. the few lines from the data I have IDAmount25156694292515670862515671-51525158941702515895342515896-2042515908802515909162515910-9625159161502515917322515918-19225159195251592052515146-525151475 Desired Result IDAmountUnique Reference2515669429125156708612515671-51512515894170225158953422515896-2042251590880325159091632515910-9632515916150425159173242515918-19242515919542515920542515146-55251514755 Please can someone help !!

Identify sequential numbers across different rows

I have this data where I want to identify all the sequential numbers across different rows and give them a unique reference

For eg. the few lines from the data I have

Desired Result

Please can someone help !!

Hi,

I am blind that I have missed it.

I just changed the point of reference. Now I am looking for the net amount equals to zero in the previous line instead of the current line.

Hi,

In order to achieve it you need to use multi row formula tool.

I have prepared a workflow for you:

The formula is:

IIF([Row-1:ID]+1=[ID],[Row-1:New Field] , [Row-1:New Field]+1)

The output:

Please mark my post as a solution if this is helpful for you!

That is what I looking to do but it doesn't give me the result I wanted for the full data I have.

Is it possible to do this on the Amount column ? For e.g a unique reference for the rows until when the Amount column nets to zero.

For e.g in the data below first three rows net to zero , then next eleven net to zero and so on.

Desired result