help with a software/excel problem

Associate
Joined
15 Nov 2005
Posts
70
I'm looking for a piece of software / excel function that could help with the following problem;

Say I have a long list of numbers and from that list I want to find those numbers which will equal or come closest to a total which i can specify. e.g. a list of 100, 50, 25, 30, 10 and say i want to find any combinations of those numbers which will equal e.g. 75, obviously the real list is much longer. Kind of like an optimizer if you will.

Does anyone know a formula or software program which can do this? The hardest part of finding an answer is knowing what exactly to search for so if anyone can point me in the right direction that would be great.

Thanks in advance.
 
Back
Top Bottom