Formula

[ridge]

Excel 2007... I have a column of 100+ numbers...all various...
I have a number from another source. I need to find which of the various numbers would add up and total the number from the other source...

 

[ridge]

13.3 Which of the numbers
55.8 in the column will equal
104.5 to a total of 254.9
66.2
31.5
65.7
51.1
99.7
46.1
etc
etc

 

[macropod]

Hi Ridge,

There has been a number of threads on this issue (eg

http://www.tek-tips.com/viewthread.cfm?qid=1485698

and

http://www.tek-tips.com/viewthread.cfm?qid=1226062).

There is also a Tek-Tips FAQ (

http://www.tek-tips.com/faqs.cfm?fid=4742)

on the same issue.

Cheers
Paul Edstein
[MS MVP - Word]

 

[papadba]

Applying cash received to receivables. . .?