Ik probeer via SOMPRODUCT richting 1000 cijfers (deelbedragen) te koppelen aan zo'n... 150ish bedragen? Alleen kom ik er niet helemaal uit, manueel is het niet te doen.. en ik weet niet zo goed hoe ik het moet uitleggen, in het engels is het wat makkelijker voor mij (gezien geleerd via engels artikel/2e taal).
Goodday, I am having some issues (note: big excel noob)
I tried to use this guide: (i cant post links but the title is How To Find All Combinations That Equal A Given Sum In Excel?, and the websites called ExtendOffice dot com.. the article;
extendoffice.com/documents/excel/3557-excel-find-all-combinations-that-equal-given-sum.html
The article used a couple of different methodes, I tried the second method (with seemed to worked yesterday with less possible combinations. (second article headline from link; Find Cells Combination That Equal A Given Sum With Solver Add-In )
I added a screenshot of the excel (it''s still loading because of SOMPRODUCT, i cant do anything excel wise, this has unironically be since 6 hours!!!! The subproblem in the left has reached (nearly) 500.000.
These are 40 of the 1500+ numbers that i need to figure out where they belong. For example, right in row Q you see 77,05, 137,40, 124,85 etc, and I need to figure out which of the K (Debet) row belongs with the combinations.... Why is it taking 6 hours? Doing it manually is hell too but to spend 6 (slowly nearing 8 hours...) for just one combination, with somewhere between 50 to 150 to go.........
Could you guys please advise me on how i can do this efficiently? I would love to answer/elaborate any questions you may have, but formost i sincerely thank you for taking the time to read this.
Thank you!
Goodday, I am having some issues (note: big excel noob)
I tried to use this guide: (i cant post links but the title is How To Find All Combinations That Equal A Given Sum In Excel?, and the websites called ExtendOffice dot com.. the article;
extendoffice.com/documents/excel/3557-excel-find-all-combinations-that-equal-given-sum.html
The article used a couple of different methodes, I tried the second method (with seemed to worked yesterday with less possible combinations. (second article headline from link; Find Cells Combination That Equal A Given Sum With Solver Add-In )
I added a screenshot of the excel (it''s still loading because of SOMPRODUCT, i cant do anything excel wise, this has unironically be since 6 hours!!!! The subproblem in the left has reached (nearly) 500.000.
These are 40 of the 1500+ numbers that i need to figure out where they belong. For example, right in row Q you see 77,05, 137,40, 124,85 etc, and I need to figure out which of the K (Debet) row belongs with the combinations.... Why is it taking 6 hours? Doing it manually is hell too but to spend 6 (slowly nearing 8 hours...) for just one combination, with somewhere between 50 to 150 to go.........
Could you guys please advise me on how i can do this efficiently? I would love to answer/elaborate any questions you may have, but formost i sincerely thank you for taking the time to read this.
Thank you!
Bijlagen
Laatst bewerkt: