SOLVED

Excel Autofill

Copper Contributor

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

 

2 Replies

@Hawkeye7720

 

Hi,

 

You can do that using a formula like this:

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

 AutoFill.png

 

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

best response confirmed by Hawkeye7720 (Copper Contributor)
Solution

@Hawkeye7720 

Maybe you need this...

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

and then copy it down.

1 best response

Accepted Solutions
best response confirmed by Hawkeye7720 (Copper Contributor)
Solution

@Hawkeye7720 

Maybe you need this...

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

and then copy it down.

View solution in original post