Thread: Returning a value in a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Returning a value in a range
To select items that combine to form a fixed sum, use Solver:

http://www.tushar-mehta.com/excel/te...ues/index.html

--
Gary''s Student - gsnu200751


"Gigi" wrote:

I want to take a sum (see example, 44) and have it look at the first row of
numbers , choose numbers that equal the total of 44 and return the value
(number) in the second row.
44

32 24 16 12 8 4
2 1 1
Any suggestions?
THANKS

Reply With QuoteReply With Quote