Filtering Data using Advanced Filter

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 DataFilterAdvanced Filter
advance 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.
advance filter1
Step 5: Result is displayed in the below image,
advance filter2

Related Topics