Filtering data with multiple conditions using advanced filter in Openoffice spreadsheet?
The advanced filter option allows up to eight filter conditions.
To use Advanced Filter, follow the below steps
Step 1: Select the columns which contain the data to filter.
Step 2: In the home tab, select Data→ Filter→Advanced Filter
Step 3: Then select the cell containing the filter condition and click the More option.
Step 4: Choose Copy results to (option to display the result in another part rather than replacing the original content) and click on the cell where you want your result to be entered.
Step 5: Result is displayed in the below image,