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?
Remove rows that are not multiple of 7
Remove rows that are not multiple of 7
OpenOffice 3.1 on Windows 10
Re: Remove rows that are not multiple of 7
Add a calculated column =MOD(ROW();7)
Filter by >0
Delete rows
Remove filter
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice