Increment Alphanumeric List

[frekels21]

I am trying to make some locations for my warehouse using Excel. I want it to automatically increment the field so that I do not have to type whole list by hand. There are 7 fields that will make up 1 location. The first location would be AA11001.

The first 2 fields will follow the same increase throughout the warehouse, so it would go AA, AB, AC, AD, BA, BB.... The first letter will continue until "Y" and the second will never go above "D"

The next to fields will vary depending on location but will follow the same general increase that the first 2 did. 11, 12, 13, 14, 15, 16, 21..... until it reaches 99.

The last three will be tied together and will need to follow 001, 002, 003... until 012.

I have tried searching the forms but I have not seen anything quite like this in my searches. Any help would be greatly appreciated.

[samba_ravi]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[shukla.ankur281190]

May be try in

A1

Please Login or Register  to view this content.

[frekels21]

I have attached a work book of what I am looking for.

Shukla I have included your formula in column A and what I am looking for in column B

[FlameRetired]

So when does AA become AB?

[frekels21]

AA would become AB after AA69009.

[FlameRetired]

Find this formula in D1 of the attached filled down to row 5000. It will work in Excel 2013 and newer.

Please Login or Register  to view this content.

PS I haven't found a way to make it stop after YD yet. Working on it.

[frekels21]

That will work perfect. Thank you very much

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[FlameRetired]

You are welcome. Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[FlameRetired]

Hold the phone!

The first part of my formula is not working as expected

BASE(DECIMAL("AA",36)+CEILING(ROWS($A$1:$A100000)/(59*9),1)-1,36)

and I don't see why or how to fix it yet.