View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
karlo karlo is offline
external usenet poster
 
Posts: 3
Default how to get excel to combine numbers to a given total

Thank you for your assistance.

I receive a list of numbers. I need to find
out which amounts will add up to a given total. How would I create a macro
to do this? Is there already an Excel function to do this that I have not
found? It would need to work with currency.

Ex: 9, 12, 7, 4, 15, 8, 10, 3 total needed 18
Solution 8+10; 3+15