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?

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.

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)

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?

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

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, What software should I use for this problem?

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?

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.