I'm trying to print warehouse bin tags. There are multiple towers that need these labels. Each Tower is eight tiers (shelves) high. The bottom tier (Tier 1) and the top Tier (Tier 8) are divided into three bins, but all other Tiers (Tier 2 - Tier 7) are divided into only two bins.
My bin numbers should show the Tower number, the Tier number, then the Bin, so for example the 5th tower, 8th tier should show three bins 05-08-01, 05-08-02, and 05-08-03.
I need to create an Excel formula that calculates these bin numbers in a column, so that my output looks like this:
04-08-02
04-08-03
05-01-01
05-01-02
05-01-03
... etc., etc.
05-07-01
05-07-02
05-08-01
05-08-02
05-08-03
06-01-01
Is there a solution to doing this where I can use formulas only?
My bin numbers should show the Tower number, the Tier number, then the Bin, so for example the 5th tower, 8th tier should show three bins 05-08-01, 05-08-02, and 05-08-03.
I need to create an Excel formula that calculates these bin numbers in a column, so that my output looks like this:
04-08-02
04-08-03
05-01-01
05-01-02
05-01-03
... etc., etc.
05-07-01
05-07-02
05-08-01
05-08-02
05-08-03
06-01-01
Is there a solution to doing this where I can use formulas only?