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?

1

1 Answer

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.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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