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

Ask Your Question
0

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
1

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

Stats

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

Seen: 599 times

Last updated: Apr 12 '20