Is there a way to auto-fill that only pull data from every tenth cell (B3, B13, B23.......B333 ect)?
View best response
You can do that using a formula like this:
If you put the formula in cell B1 and fill it down, the calculation will be applied only in every tenth cell!
Maybe you need this...
and then copy it down.