+ Reply to Thread
Results 1 to 2 of 2

Selecting every 3rd row to copy and past

  1. #1
    Registered User
    Join Date

    Selecting every 3rd row to copy and past

    Hi everyone,

    I asked a question a couple weeks back and was thankful that someone was able to help me out, saved me a ton of time.

    I'm back again as a newbie to Excel 2007 (or any excel for that matter)

    I have a lot of numbers (1061 rows of them to be exact) and I'm wanting to be able to select every 3rd number and copy and past it somewhere else. Is this possible to do all in one go? I'd hate to hand select each one.

    I want to select 1,4,7, etc (then 2,5,8,etc. and 3,6,9,etc.) in Column E all the way down to 1061

    and then do the same for column G.

    Is this possible?

    Any help would be great and much appreciated.


  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    Houston, TX
    MS-Off Ver
    I would recommend a helper column. In row of this column, =MOD(ROW(),3) and drag down as far as you need. Apply filters to the sheet, then you can select 0,1,or 2 in the helper column and each will be every third row. Highlight the data, hit Ctrl+; and then copy and paste.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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