4

I would like to copy every 10th cell from a column of several thousand. Is this possible?

Improve this question
4
  • 1
    See if this helps stackoverflow.com/questions/211062/…
    – Mitch
    Sep 14, 2012 at 17:14
  • That does help! I couldn't get the accepted solution to work, but the data sorting trick in the second answer works great. Thank you!
    – bessman
    Sep 14, 2012 at 17:26
  • Glad that it worked.
    – Mitch
    Sep 14, 2012 at 17:54
  • @Mitch I recommend slightly expanding your comment with the link into an answer, so bessman can accept it.
    – Eliah Kagan
    Oct 1, 2012 at 21:45

1 Answer 1

Reset to default
4

I found a question on stack-overflow, that addresses a similar problem. I believe that one or more of the answers might have the solution that you're looking for. The top 2 answers I think might do it for you. The first answer involves a formula, and the second one involves data sorting in a certain way.

Quoted from the Stack-Overflow answer:

In A1 of your new sheet, put this:

=OFFSET(Sheet1!$A$1,(ROW()-1)*7,0)

... and copy down. If you start somewhere other than row 1, change ROW() to ROW(A1) or some other cell on row 1, then copy down again.

If you want to copy the nth line but multiple columns, use the formula:

=OFFSET(Sheet1!A$1,(ROW()-1)*7,0)

This can be copied right too.

Click here to see the question on Stack-Overflow.

Improve this answer
1
  • Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference.
    – Seth
    Nov 10, 2016 at 21:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .