Autonumbering of Multiple Categories

Neil Watson

Hi,

I am building a centralised event capturing (by form) register which may contain 5 - 6 different types of events (incidents, actions, improvements etc.).

I want to have a number automatically assigned that is sequential, based on the previous number of the same category. Example below.

I have played around with a few options but cannot get it to work.

New entries can be added to the top or bottom of the sheet, although top is preferred but not essential (since the output will be reviewed by reports most likely).

Paul Newcome

Insert an auto-number column (called "Auto" in this example) with no special formatting and then use the below column formula:

=UPPER(LEFT([Type of thing]@row, 3)) + "-" + COUNTIFS([Type of thing]:[Type of thing], @cell = [Type of thing]@row, Auto:Auto, @cell<= Auto@row)

Paul Newcome

Insert an auto-number column (called "Auto" in this example) with no special formatting and then use the below column formula:

=UPPER(LEFT([Type of thing]@row, 3)) + "-" + COUNTIFS([Type of thing]:[Type of thing], @cell = [Type of thing]@row, Auto:Auto, @cell<= Auto@row)

Neil Watson

Thanks @Paul Newcome. Worked straight out of the box. Much appreciated.

Paul Newcome

Happy to help. 👍️