how copy formula that contains ranges so ranges do not overlap

  • Thread starter Thread starter Patty
  • Start date Start date
P

Patty

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,

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
 
Back
Top