Add ID based on previous Column

Question

hello,

how can i add ID column based on previous column

input data -

DateSettle Date 8/2/2024Settle Date 8/2/2024Settle Date 8/2/2024Settle Date 8/3/2024Settle Date 8/3/2024Settle Date 8/6/2024Settle Date 8/6/2024Settle Date 8/6/2024Settle Date 8/7/2024

Expected output -

DateIDSettle Date 8/2/20241Settle Date 8/2/20241Settle Date 8/2/20241Settle Date 8/3/20242Settle Date 8/3/20242Settle Date 8/6/20243Settle Date 8/6/20243Settle Date 8/6/20243Settle Date 8/7/20244

Luke_C · Accepted Answer

Hi @kauser

Multi-row formula tool would work:

if [Date] = [Row-1:Date] then [Row-1:ID] else [Row-1:ID]+1 endif