method/system to test add until match found

I

Ian Elliott

Thanks for any help.
I work in the finance department, and often I get a column of numbers where
several of those added up, equal another number I am given (or looking for).
If the column is short enough, I can find the number I am looking for pretty
easily, but once the column gets over 4 or 5 units, then it gets pretty
difficult. I figure there is some kind of algorithim or such to do this.
Anyone know of one available?
So like:
Column
2
1
5
6

Number given:7
Could be 2+5 or 1+6.
Kind of like that.
Thanks again.
 
R

Ron Coderre

That subject was vigorously covered in a past post.

Search for the Excel Worksheet Functions newsgroups for "find sum in list of
of numbers".
You want the post with 20+ responses.

Enjoy

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top