Thread: How do I determine which data in a range add up to a fixed number?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mray Mray is offline
external usenet poster
  
Posts: 5
Default How do I determine which data in a range add up to a fixed number?
How do i take a range of numbers and determine which numbers in the range add
up to 120? or as close to it as possible? I have list of 67 numbers totaling
710. I need to know which combination will add to 120 or as close to it as
possible, remove the first result, and repeat it until I have used all the
numbers
Reply With QuoteReply With Quote