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.
use this:
=OFFSET($C$65,19*(ROWS($1:1)-1),,,)
copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Worked like a Charm!
It is a charm!!! You're welcome and thanks for the rep.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks