Repeat a complex sequence
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)