• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto search and match figures. Is it possible in Excel?

F

fred

Member
I was approached with a seemingly very simple question.


Here is this big number $200.00 and I have a list of smaller figures $5, $10, $15, $20 all the way to $100. The $200 is made up of a combination of these smaller figures.


Question: Regardless of the combinations (obviously there could be numerous), Is there a way to command Excel to provide me its combination? Be it 100+50+30+20 or 150+50 or 175+5+20.


This question was raised by an accounting colleague. I guess she's dealing with payments or collections matching against her accounting book.
 
You can use either


Solver - http://www.officekb.com/Uwe/Forum.aspx/ms-excel/164158/Find-the-fewest-values-to-equal-a-set-total

or

Use a small VBA routine - http://www.dailydoseofexcel.com/archives/2005/10/27/which-numbers-sum-to-target/
 
Thank you, thank you, thank you!!! This is a great help and I couldn't have achieved without your help!


/BOW


Fred
 
You must log in or register to reply here.
Back
Top