Filtering Data using Standard Filter

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 DataFilterStandard 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.
standard filter1
In the below given example, the employee under Tester and Researcher designation with salary more than 5000, is filtered using Standard Filter.
standard filter2

Related Topics