In a Google Spreadsheet, I create a report sheet by entering a formula like this in the top left cell.

=FILTER(Sheet1!A2:E, Sheet1!E2:E > 0)   

This gives me all the rows in the Sheet1 from row 2 downwards where the value in column E is greater than 0.

What would be the equivalent in LibreOffice Calc?

  • Is that intended to be =FILTER(Sheet1!A2:A, Sheet1!E2:E > 0) ? – sondra.kinsey Aug 10 '17 at 19:53

Do you need automatic refresh, when the source table changed? If not, Data->More Filters->Standard Filter with the option Copy results to set to the desired sheet should do the trick.

| improve this answer | |
  • No, With filter() function, you can then pass it to another function, for example to calculate standard deviation out of the resulting filter – Xwtek Apr 21 at 0:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.