Results 1 to 3 of 3

Thread: formula to copy every 7th row into new data set

  1. #1

    formula to copy every 7th row into new data set



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Need to copy data from another set of data on the same sheet. Need to copy every 7th row. I don't want to do a copy & paste special. I want the pasted data tied to the original source and I am transposing when I paste. I have 365 cells of data and don't want to + each cell. Hope this makes sense. Help please!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Try something like:

    =INDEX(A$2:A$365,7*(ROWS($A$1:$A1)-1)+1)

    where A2:A365 contains the first column of data to extract from.

    You may need to adjust the 7 to 6 if the extracts are off by one... (not sure what exactly you meant by every 7th row)

    You can copy down and across, and you can wrap an IFERROR() around the formula to avoid errors when copying too far down.


  3. #3
    THANK YOU!!! I read so many over things that were WAY over my head. You kept it simple. thank you!!

Tags for this Thread

Posting Permissions

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