09-06-2019 08:40 AM
Is there a way to auto-fill that only pull data from every tenth cell (B3, B13, B23.......B333 ect)?
View best response
09-06-2019 09:49 AM
@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!
09-06-2019 10:00 AM
Maybe you need this...
=INDEX(B:B,3+(ROWS(B$1:B1)-1)*10)
and then copy it down.