Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 22 Jul 2018 13:44:38 +0200How to conditionally select rows, then copy-paste in Calchttps://ask.libreoffice.org/en/question/161161/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?Fri, 20 Jul 2018 12:37:22 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/Answer by JohnSUN for <p>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?</p>
https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?answer=161170#post-id-161170Make 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](https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters), 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)
![OptionsOfAdvFilter](/upfiles/15320915666261271.png)Fri, 20 Jul 2018 14:20:36 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?answer=161170#post-id-161170Comment by robertarens37 for <p>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 <a href="https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters">Advanced Filter</a>, 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)</p>
<p><img alt="OptionsOfAdvFilter" src="/upfiles/15320915666261271.png"></p>
https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161187#post-id-161187So, 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?Fri, 20 Jul 2018 18:13:04 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161187#post-id-161187Comment by JohnSUN for <p>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 <a href="https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters">Advanced Filter</a>, 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)</p>
<p><img alt="OptionsOfAdvFilter" src="/upfiles/15320915666261271.png"></p>
https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161198#post-id-161198Please 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 intendedFri, 20 Jul 2018 20:20:23 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161198#post-id-161198Comment by robertarens37 for <p>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 <a href="https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters">Advanced Filter</a>, 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)</p>
<p><img alt="OptionsOfAdvFilter" src="/upfiles/15320915666261271.png"></p>
https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161304#post-id-161304JohnSUN, What software should I use for this problem?Sun, 22 Jul 2018 13:44:38 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161304#post-id-161304Answer by robertarens37 for <p>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?</p>
https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?answer=161188#post-id-161188BTW: 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?Fri, 20 Jul 2018 18:16:28 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?answer=161188#post-id-161188Comment by David for <p>BTW: More than 700000 rows of data (10 columns each) is to much for a usable spreadsheet.</p>
<p>What software should I be using for this job?</p>
https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161197#post-id-161197This 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.Fri, 20 Jul 2018 19:36:46 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?comment=161197#post-id-161197Answer by Lupp for <p>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?</p>
https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?answer=161169#post-id-161169Use 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.Fri, 20 Jul 2018 14:16:54 +0200https://ask.libreoffice.org/en/question/161161/how-to-conditionally-select-rows-then-copy-paste-in-calc/?answer=161169#post-id-161169