car_carcharadon
New Member
- Joined
- Jun 7, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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!
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!