| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting 20 closest values from a list of 200 values | New Users to Excel | |||
| counting the last 3 values not equal to x in a list | Excel Worksheet Functions | |||
| Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
| list values equal in 2 worksheets? | Excel Worksheet Functions | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
Linear Mode
