Hi guys,

I was wondering wether there is a function in Excel which does the following. Let's say we have number 56,586.45. I got a list of about 1,000 numbers and I want to know which combinations of numbers add up to the exact amount of 56,586.45. If that function exists, is it also possible to add criteria like the maximum amount of numbers in such a combination? Help would be much appreciated.

Greetings,

Kasper