selecting values from a list to equal a given value

L

lex

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
need Excel formula that figures out which data adds up to total 4
Combine to equal a given value 1
Selecting values from a range that equal a specific total 4
Separating equal values 2
How can I use a formula to calculate a running sub-total in excel 2
How to add values in one column based on values in another column 6
Adding values for all rows in a range 6

Top