how copy formula that contains ranges so ranges do not overlap
 

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

how copy formula that contains ranges so ranges do not overlap
 

Patty,

Try this

This does B118 - B120 but dragged down 1 cell becomes B121 B123
=MAX(OFFSET(Spread!B$118,(ROWS($1:1)-1)*3,,3))

Mike

"Patty" wrote:

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