Column Formula to return 1st, 2nd, 3rd, etc. instance of a column entry.

KelliBretsch

I am looking for a Column Formula that will return the 1st, 2nd, 3rd instance of a column entry.

The following cell formula works, but I am not able to make this into a column formula and need it to be a column formula so that when our form users submit a new form the Delivery Count column automatically updates. This is my cell formula =IF([Task Name]@row > "", COUNTIF([Task Name]$1:[Task Name]1, [Task Name]@row), "")

Any help would be greatly appreciated!

Thank you!

Paul Newcome

Try inserting an auto-number column (with no special formatting) and then use something like this:

=IF([Task Name]@row <> "", COUNTIFS([Task Name]:[Task Name], @cell = [Task Name]@row, [Auto-Number]:[Auto-Number], @cell <= [Auto-Number]@row))

KelliBretsch

This worked perfectly, thank you so much!!

Paul Newcome

Happy to help. 👍️