Filtering Data using Advanced Filter

Filtering data with multiple conditions using advanced filter in Openoffice spreadsheet?

Explanation

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,

Related Topics