Excel filtering how to use the tutorial duplicate data multiple condition screening function to teach

   has many friends who do not understand the simple operation of filtering in excel, but here are some ways to filter in excel. Let's take a look.

Simple operation of    filtering in excel

   automatic filtering usage:

   1. Select the original data area (including the header), and then click "data"-"filter".

After the    operation is completed, a drop-down arrow is generated for each cell in the first row (header) of the data region.

   clicks a drop-down button that looks up, and you can see that there are three sorting functions at the top, "ascending", "descending" and "sorting by color". We can use this function to sort the data first.

Clicking the "Select all" button in the selection box below    will select everything. You can also cancel the [Select all] status directly and manually select the data to be filtered with the mouse. For example, we only need "Chen Yu", "Li Qiuxiang" and "Qin Qin".

After    clicks the [OK] button, the table only displays the data of "Chen Yu", "Li Qiuxiang" and "Qin Qin". The rest of the data is automatically hidden. The line number is displayed in blue, indicating that automatic filtering has been performed.

   We click [text filter] to see the optional menu at the next level, such as "include", "do not include", "equal to", "begin with" and so on. We can choose the specific content.

   for example, we choose "include". Enter a "small" word after [include], and then click the [OK] button. In this way, all people whose names contain the word "small" will be screened out.

   here, we can choose two conditions, the relationship between the two conditions is "meet at the same time" or "satisfy one of them". Expressed as "and" and "or" in the filter. We select "or", and in the second condition drop-down menu also select "include", followed by the word "jade".

In this way,   , all names containing the word "small" or "jade" are screened out.

   Let's select the date drop-down button in the first column to see what features Excel has for date filtering.

The first difference that    can see is that Excel automatically classifies dates, grouped by year, month and day. You can easily choose year or month data.

   clicks the date filter button to see a richer list of date filtering options.

   Note: in order to use the power of automatic filtering for date filtering, make sure that the date is in a date format recognized by Excel, not text or unrecognized date format.

   above explained the daily operation and application of screening in excel. I hope it can be helpful to you.