Selection Problems

Excel Help for Selection Problems in Automating Data Analysis Tasks

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 18 Apr 2009

There are currently no replies to the "Selection Problems" topic of the Excel Help Forum for Automating Data Analysis Tasks. Post Reply