+ Reply to Thread
Results 1 to 3 of 3

Sampling every 10th row

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Sampling every 10th row

    Hi folks,

    I'm working with spreadsheets that are 6 columns and about 120k rows. The first row are headings and so the data starts in A2. I need to take every 10th row of data to create six new columns adjacent to the original data (starting in column J or so). Also, I'm taking every 10th row starting in row 6 (which is actually the 5th row of data due to the headings) so the sample is 6, 16, 26, ect.

    Any idea how to do this?!? I've played around with the INDEX function a little bit and came up with something like this:

    =INDEX(A:F,6,1)

    However, it autofills across ok, but just copies the same row when I try to fill down. Any help is greatly appreciated. Thanks!

    Josh

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Sampling every 10th row

    Something like:

    =INDEX(A:A,10*(ROW(A1)-1)+6)


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Sampling every 10th row

    Hi jrstaples1 and welcome to the forum,

    See if the attached doesn't more explain what TMS is suggesting in his post. I always like an example to test.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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