Batch sequencing

Hi all,

I am trying to generate a batch sequence in XL.

Batch sequence is a fixed prefix of one cell (xxxx) which is the offer nr. (CEL D1)

Following that is a string of 3 digits which represents the lot number. The lot number consists of the amount of models given in column C after this number is completed it is then the next 3 digit lot for the amount of time given in column C.

Sequence needs to be generated in column I, as per example.

Attachment 426423

I am looking for a formula to do this, since currently this is done manually "bleh" for about 1300 lines.

I am sure there are better solutions for this

Hi all,

I am trying to generate a batch sequence in XL.

Batch sequence is a fixed prefix of one cell (xxxx) which is the offer nr. (CEL D1)

Following that is a string of 3 digits which represents the lot number. The lot number consists of the amount of models given in column C after this number is completed it is then the next 3 digit lot for the amount of time given in column C.

Sequence needs to be generated in column I, as per example.

Knipsel.PNG

I am looking for a formula to do this, since currently this is done manually "bleh" for about 1300 lines.

I am sure there are better solutions for this

For the formula in column C try with this.

=NUMBERVALUE(MOD(ROUNDDOWN(IF(AND(D7=D6,E7=E6,F7=F6),J6,J6+1)/10^2,0),10)&MOD(ROUNDDOWN(IF(AND(D7=D6,E7=E6,F7=F6),J6,J6+1)/10,0),10)&MOD(IF(AND(D7=D6,E7=E6,F7=F6),J6,J6+1),10))

If you want to see only the first number, go with conditional formatting with this formula:
=C7=C6

The above formulas are valid for cell C7.

Hi My apologies, I tried deleting the post.

Can ayone fin the solution for this here?

@ newdoverman.

Many thanks works like a charm. Didn't think of using a max function in a growing array. Nice insight! Many thanks man.

rep point x2 !!