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. |
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) |