How to have add a counter for duplicates in a table

Question

Hi all,

I have a set of duplicates in this table and am wondering how to create a counter which starts at 1 and then counts up for every duplicate of "File #" found. For example, my table looks like this:

File #CodeReg hours117521

153014242002351424201035152412023515241210401524121540

And I would like a counter that outputs something like this:

File #CodeReg hoursCounter117521

153011424200235114242010352152412023511524121040215241215403

I tried using the multi row formula tool with "IF [Row+1:File #] = [File #] THEN 2 ELSE [ROW-1:Counter]+1 ENDIF" but it isn't really working and doesn't count past 2.

Any help at all is appreciated!

Thanks so much,

Akarsh

Jonathan-Sherman · Accepted Answer

Hi @apaicanada,

You're right, this would be a simple multi row formula, all you would need to do is group on File # and ensure the "Values for rows that don't exist" drop down is set to "0 or Empty". The formula would be [Row-1:Counter] + 1

My configuration of the multi row formula is below:

The workflow looks like:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan