Hi everyone. I have some questions about a problem I’m trying to solve.
-We start from the data in 3 data tables. The maximum number of cells (the sum of the cells of such 3 data tables) is 9. (In the example shown below there are 4 oranges, 2 apples and 3 bananas = 9 in total). It’s just an example, because it could have been 3 oranges, 1 apple and 5 bananas (the sum is 9 again). The type of fruits is always the same (ORANGES, APPLES and BANANAS). It’s also possible that some of the fruits is 0 (for example, 9 orange and 0 apples and bananas).
-We have 3 data tables on the right. Each of them has 3 cells (so that the sum is 3+3+3=9).
What I want to achieve is that each of the tables on the right has only the same fruit. For instance, the best solution could be 3 oranges in Final Data Table 1, 3 apples in Final Data Table 2, and 3 bananas in Final Data Table 3.
As mentioned in this example, there are 4 oranges, 2 apples and 3 bananas, so it’s not possible to achieve that each of the Final Data Table has only one type of fruit. In this case, a good solution is shown below (3 oranges in Final DT1, 1 orange and 2 apples in Final DT2, and 3 bananas in DT3).
So the goal is that EACH of the Final Data Table has as many fruits of the same kind as possible.
I really need your help and I would really appreciate so so so so much if you could help me.
If you have any questions please do not heasitate to ask me.
Thank you very very very very very much!!!
P.S.: Please, find attached the Excel file.
File.xlsx (9.1 KB)