Find terms that sum to chosen total among a column of numbers?
 

Can you highlight a column of numbers and tell excel to find those numbers in
the column that sum to a number that you choose? And if there are no numbers
in the column that sum to that given total, it will indicate such?

Find terms that sum to chosen total among a column of numbers?
 

see:

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu200779


"lstutchman" wrote:

Can you highlight a column of numbers and tell excel to find those numbers in
the column that sum to a number that you choose? And if there are no numbers
in the column that sum to that given total, it will indicate such?

Find terms that sum to chosen total among a column of numbers?
 

Hello,

We had a similar question some time ago:
http://groups.google.de/group/micros...+durchsuch en

Regards,
Bernd