Home

Copy cells from column A to column C, x times (with x as variable in Column B). Easy formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-810892%22%20slang%3D%22en-US%22%3ECopy%20cells%20from%20column%20A%20to%20column%20C%2C%20x%20times%20(with%20x%20as%20variable%20in%20Column%20B).%20Easy%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810892%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20an%20easy%20formula%20to%20copy%26nbsp%3Bcells%20from%20column%20A%20to%20column%20C%2C%20x%20times%20(with%20x%20as%20variable%20in%20Column%20B).%20Easy%20formula%3F%3C%2FP%3E%3CP%3E8.B%26nbsp%3B%20%26nbsp%3B%203%26nbsp%3B%20%26nbsp%3B%208.B%3C%2FP%3E%3CP%3E4.C%26nbsp%3B%20%26nbsp%3B%201%26nbsp%3B%20%26nbsp%3B%208.B%3C%2FP%3E%3CP%3E1.A%26nbsp%3B%20%26nbsp%3B%202%26nbsp%3B%20%26nbsp%3B%208.B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B4.C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B1.A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B1.A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-810892%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811056%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20cells%20from%20column%20A%20to%20column%20C%2C%20x%20times%20(with%20x%20as%20variable%20in%20Column%20B).%20Easy%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811056%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394550%22%20target%3D%22_blank%22%3E%40EmilyAnn_55-55%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20an%20answer%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fhow-to-repeat-text-n-times-in-excel-2010%2F4059fc11-f819-43b5-91c0-41435e3a4bfe%3Fauth%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fhow-to-repeat-text-n-times-in-excel-2010%2F4059fc11-f819-43b5-91c0-41435e3a4bfe%3Fauth%3D1%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811096%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20cells%20from%20column%20A%20to%20column%20C%2C%20x%20times%20(with%20x%20as%20variable%20in%20Column%20B).%20Easy%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811096%22%20slang%3D%22en-US%22%3EThat%20is%20AWESOME!%20Thank%20you%20Sergei%20Baklan%20(MVP)!%20An%20answer%20within%20an%20hour!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811394%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20cells%20from%20column%20A%20to%20column%20C%2C%20x%20times%20(with%20x%20as%20variable%20in%20Column%20B).%20Easy%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394550%22%20target%3D%22_blank%22%3E%40EmilyAnn_55-55%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
EmilyAnn_55-55
New Contributor

Is there an easy formula to copy cells from column A to column C, x times (with x as variable in Column B). Easy formula?

8.B    3    8.B

4.C    1    8.B

1.A    2    8.B

               4.C

               1.A

               1.A

3 Replies
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions 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
7 Replies