WHERE IS THE FILTER FORMULA IN EXCEL?

First of all, the ID number must be in text format, otherwise numbers with more than 15 digits will be rounded down.

Then, fill in column A with the ID number, assuming that there is both the old 15-digit number and the new 18-digit number.

Next, enter the formula <0,,"y","n"Finally, column b formulas are populated downward.

Or instead of the outer if() formula, use the if() inside to extract the year of birth, then use the "Start" Sort & Filter filter, and then select it from the drop-down menu in the first row.

Explanation: The meaning of the formula is to judge the number of digits first, if it is 18 digits, take 4 digits from the 7th digit, if it is not 18 digits (it should be 15 digits), then take two digits from the 7th digit, and add 19 in front of it, and then judge whether the number taken out is less than 1950, yes y or n.

Be specific about what you're sifting for.

1. First of all, we open the excel on our computer, and then we enter some data in **;

2. Then we select the cells in the diagram;

3. After that, we click on the toolbar to bury the data; Check the code.

4. Then we click on filter;

5. In this way, the screening is set up, and we can filter it later, which is relatively simple.

Excel filters in the toolbar "Data".

Ways to find and use the Filter feature:

1. Open Excel** and enter the data in the cell.

and select cell A1.

2. Click on the "Data" option in the toolbar.

3. In the "Data" option, find the Bin view and the "Filter" button.

4. The filter drop-down menu appears on cell A1, click and select "123" in the pop-up options.

5. After clicking OK, all "123" will be filtered out in the cell and displayed in **. Iwaming.

<>2. Now use automatic filtering, filter out the records of "Zhang San", and sum the value, if you also use this formula to sum up, find that the sum value has not changed;

3. excel only counts the visible cells, with subtotal function: =subtotal(109,b2:b12);

4. Take a look at the summation results after automatic screening, and you can find that only the visible cells are summed;

5. It should be noted that the first arguments 9 and 109 of this function are summed, but when parameter 9 is used, the values in the rows hidden by the "Hide Row" command still participate in the summing;

6. When parameter 109 is selected, it does not participate in summing;

7. Use filter to arbitrarily select parameter 9 or 109, and the rows hidden by filtering are not involved in the calculation.

Microsoft Excel is an electronic software written by Microsoft for computers using Windows and Apple Macintosh operating systems.

The intuitive interface, excellent calculation capabilities, and charting tools, combined with successful marketing, make Excel the most popular data processing software for personal computers. With the release of Excel in 1993 as a component of Microsoft Office, Excel began to dominate spreadsheet software on all operating platforms.

Excel often needs to use filtering formulas to filter out duplicate data, how to use filtering formulas? The following is a tutorial on the use of the filter formula of excel** shared by me for you to read and learn.

Tutorial on how to use filter formulas for excel:

Filter formula using step 1: first we open excel, I use the default installation of excel 2003 in the computer, the following operations are based on this version of excel, if your version is different, the operation steps may be slightly different. To make it easier to test and understand, I created a new worksheet and entered some simple data.

Filter formula using step 2: Let's first introduce a common method to remove heavy items, that is, Excel's built-in filtering method. First select the area we need to filter, then click on the "Data" tab, find the "Filter" option and click on it, and finally we click on the "Advanced Filtering" option.

Step 3 of the filter formula: A warning box as shown in the following figure may appear, which is probably caused by improper use, but it does not affect our use, we can click OK. Then we check "Select non-duplicate records", at this time we have two operation options, one is to display the filter results in the original area, and the other is to copy to other locations, let's look at the original region display first.

Step 4: After clicking OK, we will find that the original data region has changed from duplicate data to no duplicate data. Of course, this is just a filter result, not to overwrite our source data, if you want to restore the data, just click on all to show, if you want to remove duplicates, you need to save the existing filter results.

Filter the formula using step 5: Let's take a look at copying to other locations. First of all, we choose to copy to another location, at this time the "Copy to" box will become available, we just need to click the button on the right (red line marked), select the copied area and click OK, don't forget to check "Select not to duplicate record items".

Screening Formula Using Step 6: In addition to this method, we can also use the formula method. We first sort the existing data once, either in ascending or descending order.

Then we select an empty column (or row, depending on your data) as a helper and enter 1 in the corresponding first blank column.