SOLVED
Home

Excel Autofill

Highlighted
Hawkeye7720
Occasional Visitor

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!

Solution

@Hawkeye7720 

Maybe you need this...

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

and then copy it down.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies