selecting values from a list to equal a given value
 

I have a column of $ amounts(some may be negative) . I have a figure
that one or more of the $ values in the column will equal, but I do
not know which ones they are. Is there a function to do this? I need
to be able to do this in the situation where I have a large number ov
invoices for one customer. The customer then pays a few invoices that
he selects in one lump sum, leaving me to guess which ones they are.

selecting values from a list to equal a given value
 

Check out this Tom Ogilvy classic for a way using Solver:
http://tinyurl.com/5kx9bw
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
wrote in message
...
I have a column of $ amounts(some may be negative) . I have a figure
that one or more of the $ values in the column will equal, but I do
not know which ones they are. Is there a function to do this? I need
to be able to do this in the situation where I have a large number ov
invoices for one customer. The customer then pays a few invoices that
he selects in one lump sum, leaving me to guess which ones they are.

selecting values from a list to equal a given value
 

On Dec 22, 6:59*pm, "Max" wrote:
Check out this Tom Ogilvy classic for a way using Solver:http://tinyurl.com/5kx9bw
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
wrote in message

...



I have a column of $ amounts(some may be negative) . I have a figure
that one or more of the $ values in the column will equal, but I do
not know which ones they are. Is there a function to do this? I need
to be able to do this in the situation where I have a large number ov
invoices for one customer. The customer then pays a few invoices that
he selects in one lump sum, leaving me to guess which ones they are.- Hide quoted text -

- Show quoted text -

Thanks Max
I Can't wait to give it a try
Lex

selecting values from a list to equal a given value
 

Welcome, Lex
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
wrote
Thanks Max
I Can't wait to give it a try
Lex