Auto generation of unique Numbers

[burnick02]

Good day....


I was wondering if it is possible to auto generate numbers based on the qty of a certain code. For Example:

Bill of Lading Quantity Autogenerated unique #
A000001 5 A00001001
A00001002
A00001003
A00001004
A00001005

The 3rd column auto generates 5 unique #s based on the Quantity (2nd Column) and based on the characters of Bill of Lading (column 1).


Thanks in advance...

[martindwilson]

thats not very clear! either put some seperators or post a workbook. but countif will probably do it for you

[NBVC]

Assuming your BOL is in A2 and the Quantity is in B2, then in C2:

=IF(ROWS($A$1:$A1)>$B$2,"",$A$2&TEXT(ROWS($A$1:$A1),"000"))

copied down as far as you want... Change the Quantity and see the number of codes changed.. change the BOL and see the codes change accordingly.