Howdy;

I am attmepting to use solver to adjust a dynamic range. Essentially I want
to Max a Slope function where the "Known_X" and "Known_Y" are a dynamic range.

The equation for Known_X counts a column of data and skips a number of cells
at the begining and end of the column. Known_Y is simply defined as an
offset of Known_X. The number of cells to skip at the beginning and end of
the data column are named cells, Skip_Front and Skip_End, that I manually
iterate until the slope is Max'd.

Seems like a simple concept. but I have errors when I try to use Solver.
First, setting a constraints of Integer and =1 to Skip_Front and Skip_End
does not have much effect. The Solver increments the Skip_Front to real,
which creates havoc in the defined ranges and #REF show up.

Is there a way to force Solver to make whole integer increments? Does this
problem sound like an application for Solver?

TIA
Tim