3 Replies Latest reply: Nov 14, 2012 7:44 PM by Little.John
Little.John Level 1 Level 1

Last minute  I was assigend to inventory a faciltiy tomorrow. They have the stations set up in groups of 6 and in longs rows. The naming scheme they use is 1A1, 1A2, 1A3, 1A4, 1A5, 1A6, 1B1... ect all the way to 12K6.

 

Is there away to have numbers create this labeling for me?

 

I know that I can pull down the handle at the bottom of 1A1 to get upto 1A6, but is there a formula or way to set a number system up to have it incramnet for me?


Mac Pro, Mac OS X (10.6.7)
Solved by Wayne Contello on Nov 14, 2012 3:10 PM Solved

maybe something like this will work:

 

Screen Shot 2012-11-14 at 5.08.41 PM.png

 

A1=1+INT((ROW()-1)/6/26)

B1=CHAR(CODE("A")+MOD((ROW()-1)/6, 26))

C1=MOD(ROW()-1, 6)+1

D1=A1&B1&C1

 

select A1 thru D1 and fill down as needed

 

 

Now you can copy column D and paste the values into another table so the fomulas will not be necessary (paste values using the menu item "Edit > Paste Values")