how to find several amounts in a list that add up to a certain total?

A

Andy

Hello everybody!

I'm comparing big lists of derlivery notes

Is it possible to find cells in a big list that add up to a certain
total amount?

Lets say I'm looking for a difference of 843.10. Can xls find any
combination of cells in a certain column of a big list to come to that
total?

Any help would be highly appreciated - rgds, Andy
 

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

find values that add up to certain amount 12
sum up combinations of numbers from list to get specific total 2
copy multiple records based on criteria or total amount 22
Find cells within worksheet that add up to a certain value 1
Find Macro 4
How can I sum up several check boxes conditioned by a combo box? 4
Rostering form: Adding New Lines to a table about a totals calculation. 4
How to get totals 4

Top