Excel Autofill

[Hawkeye7720]

Is there a way to auto-fill that only pull data from every tenth cell (B3, B13, B23.......B333 ect)?

[#2]

@Hawkeye7720

Hi,

You can do that using a formula like this:

=IF(MOD(ROW(),10),"",A1*2)

 

If you put the formula in cell B1 and fill it down, the calculation will be applied only in every tenth cell!

[#3 · Accepted solution]

@Hawkeye7720 

Maybe you need this...

=INDEX(B:B,3+(ROWS(B$1:B1)-1)*10)

and then copy it down.