Filtering data with multiple conditions using standard filter in Openoffice spreadsheet
To filter the data using condition (AND / OR), you can use the Standard Filter option.
To standard filter the data, follow the steps given below
Step 1: First select the columns which you want to filter.
Step 2: Select Data → Filter → Standard Filter
Step 3: In the Standard Filter window, fill the Operator (AND / OR), Field name, Condition and Value options as per your criteria and click OK.
In the below given example, the employee under Tester and Researcher designation with salary more than 5000, is filtered using Standard Filter.