Thank you for the information. I went to Tools, Add-Ins, and checked Solver
Add-ins and then clicked ok but it said it this add-in and it worked. It is
now on my tool bar. However, I have no idea how to use it. I know you said
to google for examples but I have not had much luck with that. Do you or
anyone else have experience with Solver to help me with my diliemma.
--
BeachLover
"Shane Devenshire" wrote:
[Quoted Text] > Hi,
>
> This can't be done. You can use Solver to find 1 solution, but there may be
> a large number of solutions and Solver only returns 1. And this is not a
> function, but an Excel Add-in. If you are interested in exploring this topic
> area, start by choosing Tools, Add-ins, and check Solver. Then Google Excel
> Solver. There are also sample excel files stored in the Samples folder from
> Microsoft demonstrating this sophisticated tool.
>
> Why can't it be done? Lets look at a very simple example. You have the
> following
>
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
>
> And you want to find exactly which numbers total to 10.
> 1+9
> or
> 2+8
> or
> 3+7
> or
> 4+6
> or
> 5+4+1
> ...
> --
> If this helps, please click the Yes button
>
> Cheers,
> Shane Devenshire
>
>
> "BeachLover" wrote:
>
> > I have a list of about 30 numbers in individuals cells in a column that added
> > up to over 200,000. I need to find the numbers within the 30 numbers that
> > add up specifically to 109,484.60. What formula can I use?
> > --
> > BeachLover
|