Remove rows that are not multiple of 7

Discuss the spreadsheet application
Post Reply
botolo99
Posts: 1
Joined: Tue Oct 10, 2017 10:44 am

Remove rows that are not multiple of 7

Post by botolo99 »

In OpenOffice Calc I have a list of 9000 rows with many values.

I want to remove all the rows that are not multiple of 7.

Example:

Row 1
Row 2
Row 3
Row 4
Row 5
Row 6
Row 7
Row 8
Row 9
Row 10
Row 11
Row 12
Row 13
Row 14
Row 15

Becomes:

Row 7
Row 14


How would you do that?
OpenOffice 3.1 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Remove rows that are not multiple of 7

Post by Villeroy »

Add a calculated column =MOD(ROW();7)
Filter by >0
Delete rows
Remove filter
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply