Assign number to row based on another column's value

Hello Knimers,

I have a table with two columns (A & B) and I need to add a third column that goes from 1 to N depending on where the “WO Start” value is found on the second column.

Please look at the example:


Also note that the number of rows between each “WO Start” is different.

Thank you all for your help

Hello @mcrisnidh,

please find below a small example workflow that shows how to solve your task.

Please let me know in case of questions


This is perfect, exactly what I was looking for and simpler than what I was drafting. Thank you.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.