How to have add a counter for duplicates in a table

[apaicanada]

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 #	Code	Reg hours
117521	15	30
142420	02	35
142420	10	35
152412	02	35
152412	10	40
152412	15	40

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

File #	Code	Reg hours	Counter
117521	15	30	1
142420	02	35	1
142420	10	35	2
152412	02	35	1
152412	10	40	2
152412	15	40	3

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 solution]

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