Auto increment count on Column based on values appearing in another column

Kam Reddy

Hello,

I am trying to add a formula to Column SSI Ref that will count and increment based on the number of times a number appears on SSI# column. I have completed the SSI Ref column for reference as to what I would like to see.

Thank you

Paul Newcome

You would need to insert an auto-number column (called "Auto" in this example) with no special formatting required and then a text/number column (called "Row" in this example) with the following column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then you can use this in the SSI Ref column:

=[SSI #]@row + "-" + COUNTIFS([SSI #]:[SSI #], @cell = [SSI #]@row, Row:Row, @cell <= Row@row)

Paul Newcome

You would need to insert an auto-number column (called "Auto" in this example) with no special formatting required and then a text/number column (called "Row" in this example) with the following column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then you can use this in the SSI Ref column:

=[SSI #]@row + "-" + COUNTIFS([SSI #]:[SSI #], @cell = [SSI #]@row, Row:Row, @cell <= Row@row)

Kam Reddy

Thank you - That worked perfectly

Paul Newcome

Happy to help. 👍️

Silvano Meffe

Paul, thank you so much for this solution!!! Just what I needed for my application, simple, elegant and not something I would come up with!