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

  • 1
    See if this helps stackoverflow.com/questions/211062/… – Mitch Sep 14 '12 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 '12 at 17:26
  • Glad that it worked. – Mitch Sep 14 '12 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 '12 at 21:45

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:


... 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:


This can be copied right too.

Click here to see the question on Stack-Overflow.

  • 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 '16 at 21:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.