Hello! Could really use some help with a formula. What I have is a workbook for warehouse product and what location they're assigned to in my warehouse.
My workbook lists every location and operates essentially as binary with a YES or NO as to whether the space is occupied, and if YES, it also the product assigned to that particular location.
My problem is that when locations are empty I need to account for how many pallets can fit in that location. Some product can be stacked higher than others, but if there's no product in a location, there's no data to tell me the maximum stack height - which is where I need help.
If a location is empty I need to assume the product in that location will be the same as the previous location, thus having the same stack height, so I need the Pallet Height to fill down until the next occupied location. However, if the aisle changes (the blue highlight), and the start of the new aisle is empty, I need the next occupied location to fill backwards. Typically a new aisle is where new product starts, so I don't want assumed product heights from the previous aisle (in this case Aisle Y2) flowing over into a new aisle (Z1). Z1 needs to backfill the product height from the first occupied location.
Hope that makes sense! I've been playing with this all day and it's driving me crazy. ANY help would immensely appreciated.
Thank you!!
My workbook lists every location and operates essentially as binary with a YES or NO as to whether the space is occupied, and if YES, it also the product assigned to that particular location.
My problem is that when locations are empty I need to account for how many pallets can fit in that location. Some product can be stacked higher than others, but if there's no product in a location, there's no data to tell me the maximum stack height - which is where I need help.
If a location is empty I need to assume the product in that location will be the same as the previous location, thus having the same stack height, so I need the Pallet Height to fill down until the next occupied location. However, if the aisle changes (the blue highlight), and the start of the new aisle is empty, I need the next occupied location to fill backwards. Typically a new aisle is where new product starts, so I don't want assumed product heights from the previous aisle (in this case Aisle Y2) flowing over into a new aisle (Z1). Z1 needs to backfill the product height from the first occupied location.
Hope that makes sense! I've been playing with this all day and it's driving me crazy. ANY help would immensely appreciated.
Thank you!!