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.
I have not been able to calculate the left over inventory, because two different groups can have same colors. When that happens, I cannot figure a way to calculate that.
I have attached my spreadsheet there if anyone has any idea, it would be appreciated.
Thanks!
sentinela
Bookmarks