Hi guys.
I have a list of items, in this example the partiuclar item is #10. Keeping track of purchases and items already shipped. I would like to assign a number as an identifier.
In column B, has a list of times the item was ordered. I would like to assign each order with the numbering scheme in column J, because there is no limit to the number of purchases and digits only go up to 9. I would like the number 8 to be assigned when additional identifiers are needed. Is there a formula to assign these numbers?
Bookmarks