Morning chaps
Can someone tell me whether or not it's possible to compare two columns of figures and determine which combination of numbers would, when totalled, equal another number. I have 2 worksheets which each have 100+ rows - 2 columns of data have been compared using Index/Match which works well but, in some cases, a number on worksheet 2 will have been entered on worksheet 1 as several different entries:
Worksheet 2 Worksheet 1
1000.00 1000.00
2000.00 1200.00
1500.00 800.00
1200.00 1500.00
1800.00 600.00
600.00
1800.00
The highlighted entries match exactly but those that are not highlighted match but only as a combination.
I have looked at the Solver Addin but as far as I can see the number to be checked must be entered and I will need to apply any formula you come up with to variable numbers across 100+rows. I have also looked at VBA code but it looks as though the volume of data would make that option unworkable.
Any help/advice, even if it's "that's impossible" would be gratefully received
Can someone tell me whether or not it's possible to compare two columns of figures and determine which combination of numbers would, when totalled, equal another number. I have 2 worksheets which each have 100+ rows - 2 columns of data have been compared using Index/Match which works well but, in some cases, a number on worksheet 2 will have been entered on worksheet 1 as several different entries:
Worksheet 2 Worksheet 1
1000.00 1000.00
2000.00 1200.00
1500.00 800.00
1200.00 1500.00
1800.00 600.00
600.00
1800.00
The highlighted entries match exactly but those that are not highlighted match but only as a combination.
I have looked at the Solver Addin but as far as I can see the number to be checked must be entered and I will need to apply any formula you come up with to variable numbers across 100+rows. I have also looked at VBA code but it looks as though the volume of data would make that option unworkable.
Any help/advice, even if it's "that's impossible" would be gratefully received
Comment