Hi All,

I am new to post a query but i have read many threads which was useful for me in day to day works. thanks for it. I am in need of your help here

I have a excel, where I have a list of Bill numbers (may be 1000) Column B and the amount in Column C.

I have few advance payments already been received. now the problem is I dont know which payment to be erased against which Bill.

Hence i need a help like, when i enter the value in one cell, Excel should keep adding the value in Column C (eg, c2+c3, c2+c4, c2+c5......c3+c4.....) and give me the result in separate sheet as what are the bill numbers that match the value and the amount. Excel should search all the combinations and when situation comes like the value is not matching, it can search for the nearest match value by adding two or three values too.

can any help me with this.

kindly let me know if more details required.

Regards,
Navi
09884520062