Excel Custom Filter Instances

Source: Internet
Author: User

Excel in the filtering function, convenient for us to look at various types of data, Excel screening methods, there are automatic screening and advanced screening of two kinds, which, AutoFilter, you can also use custom features, the following to explain how to use the Custom filter function!

First of all, the following figure, is a score table, there are two subjects, D is the total score column.

So, what we're going to do is, how do we filter out total points that are greater than or equal to 160 and less than 180?

The method is not difficult, look at the following steps. First, notice oh, select the column in column D, and then perform the menu action: Data → filter → auto filter.

Computer Tutorials

Such an operation, we are not difficult to find that the total number of D columns there, there is a drop-down combo box, as shown above.

Then, like the following figure, clicking on the dropdown combo box pops up the list and we select Customize in the list.

Eject the following image. Next, it's time to set the conditions.

As shown above, set the condition to be greater than or equal to 160 with less than or equal to 180, and finally, click OK.

In this way, the required data are screened out, looking at the effect of the graph. This is the example of a custom filter that I hope will help you.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.