software

I need a solution for one of the problem in excel. I will let u understand my
problme with an example

quot; suppose I have a list of invoice no. in coloum quot;Aquot; and value of those
invoices in column quot;Bquot;. I have received a single payment against some of
those invoices. I want to match that particular payment against the invoices
for which I have received payments as mentioned here

AB

X1
Y2
Z3
AA4
AB5
CD6

Suppose I have recd a payment of Rs 7.00. I want those invoices which have
sum total of Rs. 7.00

I think u have got my idea.

Pls help me out

Abhishek kedia
919312287369


If company A has outstanding invoices of 2,3,4,2,3,5

and they send you a payment of 7

this could be
2 and 5
the other 2 and 5
3 and 4
the other 3 and 4
2, 2 and 3
2, 2 and the other 3

you really need to know which invoices are being paid.

BUT if you and your customers are happy to find any invoices that total
to the payment received and mark them as paid, it might be possible, eg
you would presumably choose the oldest invoices to clear if there was a
choice. Please clarify.--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=534082Hello Mr. Robert

Thanx for the suggestion
but I think u hv not got the problem
Example of invoice is just for understanding
the actual problem for which I need the solution is

quot;is there any command by which I can get those values out of a particular
list, which has some specific sum total

like

1
2
3
4
5
6
7

I need to know what r those values out of 1 to 7, which has sum total of 8

I think u hv got me

Abhishek kedia,India
919312287269
quot;robert111quot; wrote:

gt;
gt; If company A has outstanding invoices of 2,3,4,2,3,5
gt;
gt; and they send you a payment of 7
gt;
gt; this could be
gt; 2 and 5
gt; the other 2 and 5
gt; 3 and 4
gt; the other 3 and 4
gt; 2, 2 and 3
gt; 2, 2 and the other 3
gt;
gt; you really need to know which invoices are being paid.
gt;
gt; BUT if you and your customers are happy to find any invoices that total
gt; to the payment received and mark them as paid, it might be possible, eg
gt; you would presumably choose the oldest invoices to clear if there was a
gt; choice. Please clarify.
gt;
gt;
gt; --
gt; robert111
gt; ------------------------------------------------------------------------
gt; robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
gt; View this thread: www.excelforum.com/showthread...hreadid=534082
gt;
gt;