Ask Your Question

How to conditionally select rows, then copy-paste in Calc

asked 2018-07-20 12:37:22 +0200

robertarens37 gravatar image

updated 2018-07-20 13:29:37 +0200

David gravatar image

In my Calc spreadsheet of 701,478 rows of columns A through J, how do I select, copy and past only those rows wherin: A=F and B=G and C=H and D=I and E=J?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-07-20 14:16:54 +0200

Lupp gravatar image

Use column L (e.g.) to enter into the first row of data, supposedly row 2, the formula
=AND(A2=F2;B2=G2,C2=H2;D2=I2;E2=J2) and fill it down for all the rows containing data. (Will need some time!) Then create the AutoFilter for column L and only select TRUE there from the dropdown.

BTW: More than 700000 rows of data (10 columns each) is to much for a usable spreadsheet.

edit flag offensive delete link more

answered 2018-07-20 14:20:36 +0200

JohnSUN gravatar image

updated 2018-07-20 14:59:38 +0200

Make sure that the headers of the columns of A:E and F:J are exactly the same. Highlight your data in the A:E range and apply the Advanced Filter, specifying the data in the columns of the F:J as a criterion (do not forget to specify the cell of destination in the Options)


edit flag offensive delete link more


So, with 701478 rows in columns A through E (data) and 701478 rows in columns G through K (criteria), and with columns M through Q (results) with the identical headers and still all empty, what should my Advanced Filter dialogue box look like?

robertarens37 gravatar imagerobertarens37 ( 2018-07-20 18:13:04 +0200 )edit

Please forget - this solution will not work for you: filtering a test set of data of this size did not end within an hour. You can try the @Lupp solution - it will take 2-3 minutes (approximately). But to solve such problems (with such large tables) databases are intended

JohnSUN gravatar imageJohnSUN ( 2018-07-20 20:20:23 +0200 )edit

JohnSUN, What software should I use for this problem?

robertarens37 gravatar imagerobertarens37 ( 2018-07-22 13:44:38 +0200 )edit

answered 2018-07-20 18:16:28 +0200

robertarens37 gravatar image

BTW: More than 700000 rows of data (10 columns each) is to much for a usable spreadsheet.

What software should I be using for this job?

edit flag offensive delete link more


This is not an answer, which is what this space is reserved for. I assume this is a comment for Lupp. Click on "add a comment" under his answer if you want to ask his advice for software in your case.

David gravatar imageDavid ( 2018-07-20 19:36:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-20 12:37:22 +0200

Seen: 6,518 times

Last updated: Jul 20 '18