Search range of numbers for amounts that total a given

  • Thread starter Thread starter Mike Briscoe
  • Start date Start date
M

Mike Briscoe

I would like to be able to search a range of numbers to
identify those amounts that total a given amount. There
could even be multiple combinations that would work.

An example would be that given a column that contain the
numbers 25, 50, 13, 38, 15, 8 and I wanted to search for
those amounts that total 78. The result would identify
and possibly mark 50, 13, & 15.

Is this possible?

Thanks in advance for your help!!!
 
Hi
how many values do you want to search(>70?). Also: do you want to
return all possible combinations?
 
Back
Top