Thread: Scenario?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default Scenario?

You could do this with Solver but with 3000 number, it is unlikely that
there is a unique solution.
Do you care?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"simmerdown" wrote in message
...
I have a list of numbers (approximately 3000) that sum to X. However, my
control figure is Y.

Is there a formula that will evaluate the list of 3000 numbers and return
those that when summed, equal the difference between X and Y?