Filter by numeric values

Product: MyOffice Professional

Application: Spreadsheet Desktop version

To filter a range of cells containing numbers based on a condition, follow these steps:

1.Create a range of filtering containing numbers.

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

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

filtering_window_numeric

4.In the Condition by number drop-down list, select a condition for filtering:

Comparison condition for numbers	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, click the t_down button and select a value from the range in the drop-down list, or enter another value manually. When you enter a value, the range values are searched and the corresponding options are displayed in the drop-down list. To clear the input field, click the clear_input_field button.

filtering_window_numeric_search

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.

Was this helpful?

Yes