Thanks for the warning on Solver. My data is fairly smooth with minor
ripples so I don't think it will pick a bad solution.
Where do I find cubic spline info?

"Dana DeLouis" wrote:

One thing that comes to mind about Solver is that in a 6th order polynomial,
Solver may zero in on the wrong local minimum/maximum. Do you have a lot
of data points? Maybe you could smooth your curve with a 3 degree
polynomial, or perhaps run a cubic spline equation.

--
Dana DeLouis
Win XP & Office 2003


"Ralph" wrote in message
...
Solver will do it. Is there any way to automate Solver so that it works
like
a worksheet function?

"Ralph" wrote:

I have a 6th order polynomial fit of data points. I want to find the
number
that would give the maximum value of this curve. Is there a formula that
would do this without creating a large table and evaluating the table for
the
Max?
(eg. derivative where slope = 0 indicates maximum)