I have a formula on one worksheet that finds the max value of 3 cells on
another worksheet. I want the formula below it to move to the next three
cells not overlap the rows. When I drag them it copies overlapping cells.
What I am looking for is example: =MAX(Spread!B118:B120) next row the formula
would be =MAX(Spread!B121:B123) how do you do that where you do not have to
enter each formula for each row?
thank you
--
Patty