We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

libreoffice calc find and copy all matching data in rows

asked 2020-04-12 01:55:42 +0200

PbWerk gravatar image

Would like to know if there is a way to Find and then Copy all matching data in a row. I have used the Find option but in only selects the one column that the search term appears in.

I want the find the search term and the copy all the rows and columns that are included in the search to copy to a separate data base.

I am trying to extract only payments that I have made on a weekly basis from my bank statement .csv file

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-04-12 08:08:35 +0200

JohnSUN gravatar image

Use Data - More Filters - Standard Filter and Copy results to in Options

This shows how to copy non-empty values ​​to a new range. Of course, you can use other conditions to solve your task.

Using Filter To Copy Result

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-12 01:55:42 +0200

Seen: 599 times

Last updated: Apr 12 '20