Sep 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)?
Sep 06 2019 09:49 AM
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!
Sep 06 2019 10:00 AM
SolutionSep 06 2019 10:00 AM
SolutionMaybe you need this...
=INDEX(B:B,3+(ROWS(B$1:B1)-1)*10)
and then copy it down.