Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Libreoffice - OFFSET function

  1. Jun 22, 2015 #1
    I'm trying to use the OFFSET function in libreoffice to copy every 37th row in a given column but I am unable to do it. I've lost the last 3 hours searching all over the internet and the given answers don't seem to work on my libre-office! I'm seriously getting pissed here.

    So, let's say I have a huge column of data. For example, I have data going from H5 to H2000. I want to select every 35th value. That is, I want the H40, H75, H110, so forth and so on. How do I go about doing that?
  2. jcsd
  3. Jun 22, 2015 #2


    User Avatar
    Science Advisor
    Gold Member

    Here's what I came up with:

    Set up a column with N, 2xN, 3xN... values in consecutive cells. These are the Nth values to take from your base data column. So just put 35 (or whatever you need) in the first row, 2x35 in the next one, and drag the two down to fill as many as you need.

    Set a column for your output values with the first cell:
    OFFSET ($H$5;Q1;0)
    Drag the first OFFSET function down.
    Taking every second value from the A column and displaying it in the C column.
    (the function displayed is OFFSET, just in another language)
    Does this work?
  4. Jun 22, 2015 #3
    @Bandersnatch thank you. That does work :P
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook