Home / ubuntu / Questions / 187833
Accepted
bessman
Asked: 2012-09-15 09:11:04 +0800 CST

LibreOffice Calc - Perform operation on every nth cell

  • 772

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

libreoffice

1 Answers

  1. Best Answer

    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.

    • 4