View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gigi Gigi is offline
external usenet poster
 
Posts: 3
Default Returning a value in a range

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