I have 6 groups and I have bought different color, and size t-shirts for each group. Now, in this spread sheet I am trying see what color needs to go to each group. Different groups can have same colors, but a group must have only one color. The only requirement is if I have enough shirts for that group, then they can have the shirts.
I have not been able to calculate the left over inventory, because two different groups can have same colors. In other words, when I pick blue, it deducts from my inventory, and if group be gets blue, I am not sure how to calculate that, because the root inventory is no longer correct.
When that happens, I cannot figure a way to calculate that.
Does anyone have any idea how do to this?
Posted by SENTINEL on
There are currently no replies to the "Selection Problems" topic of the Excel Help Forum for Automating Data Analysis Tasks.