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!

Hi,

Am Fri, 26 Apr 2013 20:11:39 +0100 schrieb dlireland:

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]

e.g. write in H1:Hn the Process and in I1:In the number for this
process.
Then you can try in A4:
="25."&VLOOKUP(C4,$H$1:$I$10,2,0)&"."&COUNTIF($C$4 :C4,C4)&"."
and copy down.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Hi again,

Am Fri, 26 Apr 2013 22:19:07 +0200 schrieb Claus Busch:

Then you can try in A4:
="25."&VLOOKUP(C4,$H$1:$I$10,2,0)&"."&COUNTIF($C$4 :C4,C4)&"."

you don't need the dot at the end.
Try:
="25."&VLOOKUP(C4,$H$1:$I$10,2,0)&"."&COUNTIF($C$4 :C4,C4)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Wow, that worked perfectly! Thank you so much!