Hi,
Im trying to Get the max value from every fourth row from another spreadsheet. My cells look like this:
MAX(Data!B34:Y34)
MAX(Data!B38:Y38)
MAX(Data!B42:Y42)

and so on. The problem is I have 900 rows of data so doing this by hand would take lots of effort. When I try to copy these formula ie. drag the green box down, in the next cell I get MAX(Data!B37:Y37) when i would want to get MAX(Data!B46:Y46). How can I keep the same interval in cells when copying this formula down?

Thanks in advance!