Hello everyone,
i have this problem i have to solve. It's not that easy but here it is .... In column A i have a list of sizes maybe Hundreds Thousands.. and they might be from 10 to 100 in column B. i also have a certain target range for example 95 to 100.
i want to add all numbers in column B in order to result from 90 to 100(my target range) for example A1 with A10 = 100, A2+A3+ A11 =90, A4+A6 =90, then A5+A12 = 95 and so on.. The numbers which are used cannot be used again. The result will be a table with this info as the table below SIZE 1 and SIZE 10 100 etc or A1 and A10 something like that. I know it's hard but if anyone has an idea please be free to share
<tbody>
</tbody>
<tbody>
</tbody>
i have this problem i have to solve. It's not that easy but here it is .... In column A i have a list of sizes maybe Hundreds Thousands.. and they might be from 10 to 100 in column B. i also have a certain target range for example 95 to 100.
i want to add all numbers in column B in order to result from 90 to 100(my target range) for example A1 with A10 = 100, A2+A3+ A11 =90, A4+A6 =90, then A5+A12 = 95 and so on.. The numbers which are used cannot be used again. The result will be a table with this info as the table below SIZE 1 and SIZE 10 100 etc or A1 and A10 something like that. I know it's hard but if anyone has an idea please be free to share
SIZE 1 | 90 | A1+A10 | 100 | Range 90- 100 | RESULTS | ||
SIZE 2 | 50 | A2+A3+A11 | 90 | SIZE 1 and SIZE 10 | 100 | ||
SIZE 3 | 30 | SIZE 2 and SIZE 3 and SIZE 11 | 90 | ||||
SIZE 4 | 60 | A4+A6 | 90 | SIZE 4 and SIZE 6 | 90 | ||
SIZE 5 | 70 | A5+A12 | 95 | SIZE 5 and SIZE 12 | 95 | ||
SIZE 6 | 30 | SIZE 7 and SIZE 16 | 100 | ||||
SIZE 7 | 80 | A7+A16 | 100 | ||||
SIZE 8 | 40 | ||||||
SIZE 9 | 80 | ||||||
SIZE 10 | 10 | ||||||
SIZE 11 | 10 | ||||||
SIZE 12 | 25 | ||||||
SIZE 13 | 35 | ||||||
SIZE 14 | 75 | ||||||
SIZE 15 | 95 | ||||||
SIZE 16 | 20 |
<tbody>
</tbody>
Thanks |
<tbody>
</tbody>
Last edited: