Filter by numeric values

Product: MyOffice Professional, MyOffice Education

Application: Spreadsheet Desktop version

To filter a range by condition for numeric values, follow these steps:

2.Click the editor_filter_on_drop_active Sort and filter button in the upper cell of the column where you want to filter the data.

3.In the window that opens, select By condition filtering method.

4.In the Condition drop-down list, select the condition to filter by:

Comparison condition for numerical values	Description
Equal to	The value in the cell should be equal to the value of the argument.
Not equal to	The value in the cell should not be equal to the value of the argument.
Greater than	The value in the cell should be greater than the value of the argument.
Greater than or equal to	The value in the cell should be greater than or equal to the value of the argument.
Less that	The value in the cell should be less than the value of the argument.
Less than or equal to	The value in the cell should be less than or equal to the argument value.
Between	The value in the cell should be greater than or equal to the value of the first argument (Value 1) and less than or equal to the value of the second argument (Value 2).
Above average	The value in the cell should be greater than the arithmetic mean of the range.
Below average	The value in the cell should be less than the arithmetic mean of the range.
Top 10	If you select the Numbers option in the Type box, the specified number of rows with the largest values is selected. The number of rows is specified in the Quantity box. If you select the Percentage option in the Type box, the specified percentage of rows with the highest values of the total number of rows is selected. The percentage of rows is specified in the Quantity box. In this case, if the value of (n+1) row is equal to the value of the nth row, then the (n+1) row is also selected for display.
Bottom 10	If you select the Numbers option in the Type box, the specified number of rows with the smallest values is selected. The number of rows is specified in the Quantity box. If you select the Percentage option in the Type box, the specified percentage of rows with the smallest values of the total number of rows is selected. The percentage of rows is specified in the Quantity box. In this case, if the value of (n+1) row is equal to the value of the nth row, then the (n+1) row is also selected for display.

5.In the Value box in the drop-down list, you can select a value from the range or enter another value manually. As you type, the range values are searched and a drop-down list offers relevant options. To clear the input field, click the clear_input_field button.

6.Click Apply.

The appearance of the sort and filter button may differ from the one shown here because it depends on whether sorting has been previously applied, the sort order (ascending or descending), and whether a filter has been previously applied:

– editor_filter_on_drop_active : No sorting or filtering applied.

– filter_applied : Filter applied, no sorting applied.

– sorting_ascending_icon : Sorted in ascending order with no filter applied.

– sorting_descending_icon : Sorted in descending order with no filter applied.

– sorting_ascending_filter_icon : Sorted in ascending order with filter applied.

– sorting_descending_filter_icon : Sorted in descending order with filter applied.

To clear the condition filter applied to a column for numeric values without resetting the sorting, follow these steps:

1.Click filter_applied Sort and filter.

2.In the window that opens, select By value filtering method.

3.Click Apply.

To clear the filter applied to a column by condition for numeric values along with sorting, do the following:

1.Click filter_applied Sort and filter.

2.In the window that appears, click Clear.

Was this helpful?

Yes