Hi,
I'm trying to see if its possible to do in excel or to build a macro for the following situation:
We have multiple types of apples (Fuji, Red, Gala, Golden, HoneyCrisp, and Green). All apples are each uniquely barcoded that are evenly distributed into 6 baskets. When it comes to uneven numbers divisible by 6, we add back the apples into one of the other baskets (in others words, would restart the count OR basket 1 & 2 would get two apples from Red); can't have part of an apple. -- We want to keep the types of apples evenly distributed among the baskets.
After grouping the apples into their respective baskets, is there a way to evenly redistribute the apples based on the number of baskets while keeping the types of apples evenly distributed; in this case 6. Since we have a total count of 45 apples, there should be 7 apples in each basket; with the exception of 3 baskets having 8 apples? As you can see below in the counts of each baskets, we have 11 apples that are in basket 1 and each basket is suppose to have about 7.
We can move the Fuji apples to Basket 4, 5, 6 -- like so instead of starting at 1, 2, 3:
I'm trying to see if its possible to do in excel or to build a macro for the following situation:
We have multiple types of apples (Fuji, Red, Gala, Golden, HoneyCrisp, and Green). All apples are each uniquely barcoded that are evenly distributed into 6 baskets. When it comes to uneven numbers divisible by 6, we add back the apples into one of the other baskets (in others words, would restart the count OR basket 1 & 2 would get two apples from Red); can't have part of an apple. -- We want to keep the types of apples evenly distributed among the baskets.
After grouping the apples into their respective baskets, is there a way to evenly redistribute the apples based on the number of baskets while keeping the types of apples evenly distributed; in this case 6. Since we have a total count of 45 apples, there should be 7 apples in each basket; with the exception of 3 baskets having 8 apples? As you can see below in the counts of each baskets, we have 11 apples that are in basket 1 and each basket is suppose to have about 7.
We can move the Fuji apples to Basket 4, 5, 6 -- like so instead of starting at 1, 2, 3:
