+ Reply to Thread
Results 1 to 5 of 5

Excel: Copy Intervals to Other Cells

  1. #1
    Registered User
    Join Date
    10-08-2016
    Location
    SF cA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel: Copy Intervals to Other Cells

    Hello and thank you in advance. I am trying to copy intervals EX:

    Information from C65, C84, C103, C122, C141, C...

    I would like to grab the data from every other 19 rows starting at C65. I would then like to drop that into Another Row. I do not want it on another sheet.

    Thank you.
    Last edited by xsilencerx; 10-08-2016 at 01:38 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Excel: Copy Intervals to Other Cells

    use this:


    =OFFSET($C$65,19*(ROWS($1:1)-1),,,)

    copied down.
    Glenn



  3. #3
    Registered User
    Join Date
    10-08-2016
    Location
    SF cA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel: Copy Intervals to Other Cells

    Worked like a Charm!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Excel: Copy Intervals to Other Cells

    It is a charm!!! You're welcome and thanks for the rep.

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel: Copy Intervals to Other Cells

    Where do you want the results to appear?

    Assuming you want the results to appear in cell A1 downwards:

    =INDEX(C$65:C$1000,ROWS(A$1:A1)*19-18)

    Copy down as needed.

    Adjust for the correct end of range where I've used down to C1000.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-27-2016, 12:41 AM
  2. Copy cell values in other column with variable intervals
    By ce169 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2016, 04:28 PM
  3. Calculating quantiies from irregular intervals to regular intervals
    By abhi1421 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-15-2014, 06:34 AM
  4. [SOLVED] Copy With Intervals Paste With No Intervals.
    By gorinw10 in forum Excel General
    Replies: 12
    Last Post: 07-20-2013, 12:23 PM
  5. Copy and paste data at time intervals
    By Andrew6279 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2010, 09:10 PM
  6. [SOLVED] Counting cells with intervals
    By Paulo Araújo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Counting cells with intervals
    By Paulo Araújo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1