Lauren,

With a hundred different items, there are over 2^100 possible ways to
combine them. You would need a supercomputer - or maybe even multiple
supercomputers. If you had fewer than 25, you could do it.

HTH,
Bernie
MS Excel MVP


"Lauren qt314" <Lauren wrote in message
...
Thank you for your assistance.

I receive a list of numbers, usually over one hundred items. 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