+ Reply to Thread
Results 1 to 3 of 3

How to duplicate row(s) by a factor of 11?

  1. 06-03-2021, 02:37 PM #1
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    How to duplicate row(s) by a factor of 11?

    Good afternoon.
    I have in column A,B,C my raw data.
    I would like when I can click on the range A2,B2,C2 to duplicate the data like the picture.

    I have 120 stocks, so if it is possible to click on the range A12:C1320 directly to obtain the duplicate of all my raws instantly could be great.
    Capture.PNG

    Thank you for your help!
    Attached Files Attached Files
    Last edited by Luu4466; 06-04-2021 at 03:45 AM.
    Reply With QuoteRegister To Reply
  2. 06-03-2021, 05:27 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: How to duplicate row(s) by a factor of 11?

    try this in E2 and drag right then down...
    =INDEX(A$2:A10000,ROUNDUP(ROW(A1)/11,0))

    edited, corrected formula.
    Last edited by Sam Capricci; 06-03-2021 at 09:44 PM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 06-04-2021, 03:45 AM #3
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Re: How to duplicate row(s) by a factor of 11?

    Excellent Sam Capricci, it's working perfectly!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Factor Up and Factor Down Values Formula
    By alive555 in forum Excel General
    Replies: 6
    Last Post: 08-14-2015, 12:01 PM
  2. The 'WOW' Factor
    By Hopefull in forum Excel General
    Replies: 1
    Last Post: 09-11-2011, 04:07 PM
  3. bradford factor
    By Tjenkins in forum Excel General
    Replies: 8
    Last Post: 10-29-2010, 06:38 AM
  4. Packing factor
    By Navneet in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-03-2010, 09:50 AM
  5. [SOLVED] IF FACTOR?
    By Bernadette in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 09:20 AM
  6. [SOLVED] Growth Factor
    By Laura in forum Excel General
    Replies: 2
    Last Post: 05-15-2006, 05:50 PM
  7. [SOLVED] Getting Zoom Factor
    By HA in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-05-2006, 06:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1