Formula for column to count number of duplicate items in a table in consecutive order

1

Hey all,

I am trying to figure out a formula to count duplicate items in ascending order. Here is an example. I have invoices from email automatically create a new row, but some vendors send a single file that has multiple invoices. So when we duplicate those rows I want to be able to visualize which duplicate it is.

It would also be nice to have a button that you can add the number of copies you want and it will duplicate it that way, but maybe I can figure that out later.

Any help would be appreciated. Thanks!

Sample Table

2

OK I have solved your riddle! This is done by creating a column [RowID] where you get each row’s ID with rowID(thisrow).

Then you need to create an array of the RowIDs that match the Invoice number:

[Table 1].Filter(Name=thisRow.Name).RowID

Then you search that array for the row’s respective position in the array:

Find(thisRow.RowID,thisRow.[RowID Array] )

https://cdn.zappy.app/3d6c2c7e3e1deec43298038e498b1f16.gif(image larger than 4096KB)

Enjoy!

2 Likes
3

Awesome. Thanks so much! That worked perfectly.