Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
See if this helps… – 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
up vote 1 down vote accepted

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.

Click here to see the question on Stack-Overflow.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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