Ask Your Question

Selecting / copying nth rows in Libre Office Calc

asked 2016-08-29 15:04:24 +0200

SeventhSense gravatar image

Hi all! Please guys, how do I copy every nth (in my case 120th) line in Calc from ex. column A to column B?

Manually selecting is not an option since I have thousands of lines. I have already tried this solutions which didn't work unfortunately:

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-29 19:18:13 +0200

mark_t gravatar image

Works for me

=OFFSET($A$2, (ROW()-2)*120,0)

Don't forget to copy down the column B for enough cells to suit your list.

Depending on your language installed you might need ";" instead of ",".

If you cant to copy the formula down the length of the table without showing 0 for blank cells try:

=IF(OFFSET($A$2, (ROW()-2)*120,0)<>"",OFFSET($A$2, (ROW()-2)*120,0),"")

Attached Example, Untitled 16.ods might help you see it working.

edit flag offensive delete link more


I can't upvote this because I don't have enough points (WTF?). So I have to comment, that this worked for me.

vnfkdfj gravatar imagevnfkdfj ( 2018-04-26 21:29:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-29 15:04:24 +0200

Seen: 3,245 times

Last updated: Aug 29 '16