Start a new Record ID every time a new value pops in another column

Question

INPUT:

OUTPUT:

Please refer to above attached pics of INPUT and desired OUTPUT. I was able to flag the different ID's but I was not able to start a new count/ record ID every time a new ID came up. It might be a really simple solution but I am confused. Any help will be appreciated. Thanks!

I have attached the INPUT and desired OUTPUT files.

INPUT_1.csv

Output_1.xlsx

kathleenmonks · Accepted Answer

Hi @bmittal11,

You can use a multi-row formula to do this. Here is the formula I wrote (note that I named the new field "Record_ID2" so as to not be confused with the one you already created above.) Let me know if this helps!

IF [ID] =[Row-1:ID]
THEN [Row-1:Record_ID2]+1
ELSE 0
ENDIF