Copying formulas while keeping formating

[Bradh]

I keep learning how much i don't know about Excel...i want to drag and fill down a bunch of cells, but would like the formula to keep going in the same intervals:


if i have =B8 in cell M1, then =B18 in cell M2, B28 in M3, etc...can i copy that some how to keep the interval going up by 10 each time?

[Admin]

Hi

in M1 and copied down,

=INDEX($B$8:$B$1000,ROWS(M$1:M1)*10-10+1)