Geek Answers Handbook

Determining which numbers in the array are equal to a certain amount

I present this question as a general mathematical problem. I am going to tag it with Visual Basic, since the solution will most likely be implemented in a spreadsheet.

I have a mailing list with the number of widgets in each batch. Each batch was loaded either onto truck No. 1 or onto truck No. 2. Given the total number of widgets on each truck, how can I determine what loads were on each truck?

For example, the total number of widgets in each truck is downloaded here:

Truck #1  83,240 
Truck #2  63,460 
         -------
         146,700

And here is a detailed shipping list.

SHIPMENT ID  QUANTITY 
90006           340 
93806         2,460 
93906        22,980 
92506         5,960 
96306         3,580 
96406         3,320 
96906         2,680 
97306         1,160 
99206         9,780 
95005        15,300 
95006         2,980 
96008        22,320 
95606        28,580 
90206         5,020 
90306         3,160 
94006         1,140 
94406         4,640 
94606         7,900 
98606         3,400 
            -------
            146,700

What shipments were in Truck # 1 and Truck # 2?

+5
source share
1 answer

. - Stack Exchange Math. . . , , .

+5

More articles:


All Articles