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

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 close merge delete

Sort by » oldest newest most voted

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.

more

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)

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?

( 2018-07-20 18:13:04 +0100 )edit
1

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

( 2018-07-20 20:20:23 +0100 )edit

JohnSUN, What software should I use for this problem?

( 2018-07-22 13:44:38 +0100 )edit

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?

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.