A1 B1C1 A2 B2 C2 A3 B3 C3

[car_carcharadon]

I am trying to label a number of properties with aisles and racks. I am trying to get a string to increment in a couple of places. I have a solution that was manual and I know there is a better way - I just don't know it.
Building 1 (BLD1) has 1000 aisles and racks that go 8 high. I want to identify them as
BLD11000A - for Building 1, aisle 1000, Rack A
BLD11000A - for Building 1, aisle 1000, Rack B .......... up to
BLD11000A - for Building 1, aisle 1000, Rack H
then
BLD11001A - for Building 1, aisle 1001, Rack A
.......... up to
BLD11001H - for Building 1, aisle 1001, Rack H
and so on

I created
=CONCATENATE("BLD1",(1000+INT((ROW(B1)-1)/8)),A1)
works great on the Building and Aisle, but I couldn't figure out how to get the racks label to ONLY go A - H. What I ended up doing is in column A, entering A, B, C....H in the first 8 rows and then copying the pattern all the way down.

any education would be appreciated!

 

[car_carcharadon]

I am trying to label a number of properties with aisles and racks. I am trying to get a string to increment in a couple of places. I have a solution that was manual and I know there is a better way - I just don't know it.
Building 1 (BLD1) has 1000 aisles and racks that go 8 high. I want to identify them as
BLD11000A - for Building 1, aisle 1000, Rack A
BLD11000A - for Building 1, aisle 1000, Rack B .......... up to
BLD11000A - for Building 1, aisle 1000, Rack H
then
BLD11001A - for Building 1, aisle 1001, Rack A
.......... up to
BLD11001H - for Building 1, aisle 1001, Rack H
and so on

I created
=CONCATENATE("BLD1",(1000+INT((ROW(B1)-1)/8)),A1)
works great on the Building and Aisle, but I couldn't figure out how to get the racks label to ONLY go A - H. What I ended up doing is in column A, entering A, B, C....H in the first 8 rows and then copying the pattern all the way down.
View attachment 66488

any education would be appreciated!

Uggghhh I just realized i have a stupid typo in my text above. What I am trying to accomplish is (really)
BLD11000A - for Building 1, aisle 1000, Rack A
BLD11000B - for Building 1, aisle 1000, Rack B .......... up to
BLD11000H - for Building 1, aisle 1000, Rack H
then
BLD11001A - for Building 1, aisle 1001, Rack A
.......... up to
BLD11001H - for Building 1, aisle 1001, Rack H
and so on

 

[Fluff]

How about in B1 only (it will spill down)

="BLD1"&1000+INT(SEQUENCE(8000,,0)/8)&CHAR(MOD(SEQUENCE(8000,,0),8)+65)

 

[car_carcharadon]

Outstanding!!!! That is it! Thank you very much!!!! I am not familiar (yet) with Sequence.

 

[Fluff]

You're welcome & thanks for the feedback.