Tushar,

thanks for your great help, but the template does work perfectly. may i can
elaborate more as below for your better understanding

DO# Delivered qty
1a 123
2a 234
3a 567
4a 123
5a 245

so my target is 246 qty, can i using formula so that i can know which DO can
make up 246 qty? answer: 1a + 4a

Lawrence


"Tushar Mehta" wrote:

In article ,
says...
Hi,

i have few thousand column of sales' DO list, but cutomer's received qty and
our sales qty doesn't match by 11444 qty.

From the sales data, could i know which DO can make up this qty 11444. by
using any formula?

thanks in advance!!!

lawrence

If you are looking to match only complete sales, you should be able to
adapt the idea at
Find a set of amounts that match a target value
http://www.tushar-mehta.com/excel/te...ues/index.html