SOLVED
Home

Excel Autofill

%3CLINGO-SUB%20id%3D%22lingo-sub-841123%22%20slang%3D%22en-US%22%3EExcel%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-841123%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20auto-fill%20that%20only%20pull%20data%20from%20every%20tenth%20cell%20(B3%2C%20B13%2C%20B23.......B333%20ect)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-841123%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-841296%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-841296%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F404784%22%20target%3D%22_blank%22%3E%40Hawkeye7720%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20do%20that%20using%20a%20formula%20like%20this%3A%3C%2FP%3E%3CPRE%3E%3DIF(MOD(ROW()%2C10)%2C%22%22%2CA1*2)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20683px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130510i81C462529C350E06%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22AutoFill.png%22%20title%3D%22AutoFill.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20put%20the%20formula%20in%20cell%20B1%20and%20fill%20it%20down%2C%20the%20calculation%20will%20be%20applied%20only%20in%20every%20tenth%20cell!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-841409%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-841409%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F404784%22%20target%3D%22_blank%22%3E%40Hawkeye7720%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20you%20need%20this...%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DINDEX(B%3AB%2C3%2B(ROWS(B%241%3AB1)-1)*10)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eand%20then%20copy%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies