formula to copy every 7th row into new data set

brendaoc

New member
Joined
Jul 8, 2014
Messages
9
Reaction score
0
Points
0
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!
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
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.
 

brendaoc

New member
Joined
Jul 8, 2014
Messages
9
Reaction score
0
Points
0
THANK YOU!!! I read so many over things that were WAY over my head. You kept it simple. thank you!!
 
Top