How to output value in excel interval range

excel interval range value output

First open the table excel file that needs to be filtered, click the menu bar-data -Filter-Automatically filter, as shown in the picture below.

Recommended: "Excel Tutorial"

After selecting automatic filtering, a drop-down arrow appears in the data column. Click the drop-down arrow to display the filter menu. . Each drop-down menu corresponds to a filter category, as shown in the figure below.

Then click Numeric Filter to perform specific data filtering or data filtering for a certain numerical interval for table files containing a large amount of data, as shown in the figure below.

Filter out students whose scores in multiple categories are greater than 80 points in four subjects, as shown in the figure below.

Then click the menu bar-data-filtering-advanced filtering to open the advanced filtering menu, as shown in the figure below.

Then open the advanced filtering, enter the cell range or use the mouse to check the required area, and check the list area and condition area respectively, as shown in the figure below.

If you want to filter the data to be displayed separately, directly check to copy the filter results to other locations, click on the cell that needs to be stored, and click OK to get the filter The result is as shown in the figure below.

The above is the detailed content of How to output value in excel interval range. For more information, please follow other related articles on the PHP Chinese website!