Hello,

I'm wondering if there is a way to create an autonumber that number categories based on data in another column. This number will also need to have a prefix (25).

I have a list of requirements that are grouped by Process/Activity (column C). In column A I need an Identifier that will look like this:

25.[Process #].[autonumber]

I attached screen shots of what my sheet looks like and the type of numbering I would like to achieve.

I have another sheet that contains all the process/activity labels. I was thinking I could assign a number to each process and use a lookup to return the number in the identifier that is associated with each process, but I am not sure how to get the prefix or the autonumber.

Any assistance is appreciated. Thanks!