Selection ProblemsExcel Help for Selection Problems in Automating Data Analysis Tasks |
|
|||||
|
|
||||||||||
|
||||||||||
| Forum Topic | Reply Login |
| Selection Problems | Rate this: (3/5 from 1 vote) |
 | Hello everyone. I am stuck on a problem in a spread sheet. 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? Thanks! | |
| SENTINEL | ||
| Posted by SENTINEL on | ||
| There are currently no replies to the "Selection Problems" topic of the Excel Help Forum for Automating Data Analysis Tasks. Reply |
| Find relevant Excel templates and add-ins for Selection Problems in the Excel Business Solutions Directory |
| Find
Excel templates and add-ins in the Excel Business Solutions Directory |