How can I make Excel or maybe some other program search through 1
different numeric values say A1 thru A14 and list out the combinatio
of cells that add up to exactly equal to a number that I enter into
particular cell?

For example if the numbers were 1-14 in the 14 cells and I enter a 2
in a selected input cell, I want the program to list out the cells tha
add up to 25 like A1,A10,A14 or list the actual values that equal 2
like 1,10,14 in a selected output cell.

Can this be done in Excel? If so please explain how? If not do you kno
of a program that I could purchase that will allow me do this.

Thanks

--
Message posted from http://www.ExcelForum.com