How to find people s names in Excel or display by last name

Excel is very powerful, not only in data processing, but also in the auxiliary aspect of humanization.

Take the search of people's names as an example; If you have thousands of names in Excel, how can you quickly find the name you are looking for, or how do you show the names of people with the same surname and hide the other surnames?

Method steps.

In this article, we will answer that question for you!

Worksheet for one surname!

Below, according to the purpose of this article, we will answer the technical problems for you!

Find names directly.

In the Excel work window, perform the following operation:

Execute Find, and after that, the Find and Replace dialog box pops up!

As shown above, switch to the "Find" tab, then enter the last name or full name of the person you want to find in the search content input box, click "Find All" or "Find Next", and after that, it will be the same as above! When we find the name of the person, excel will automatically run to that position and select the current row, so that we can see it at a glance.

Finding and displaying castes of the same caste.

For a very large amount of name data**, if you only want to see the name of a person with a certain surname, and hide the data of other surnames, then we can use the following methods to operate.

Select the whole column with the last name, such as column A in this article, note, click the column header of column A to select, and then execute "Data" "Filter" and "Auto Filter", at this time, a drop-down list box will appear in the A1 cell of column A. As shown below!

Then, click the button of the drop-down list box of A1 and select "Custom" in the list, as shown below!

Finally, the "Customize Auto Filter Method" dialog box will pop up, as shown below!

In the image above, select "Contain" under the name, enter "Zhang" to the right of it, and click OK to exit.

At this point, you will see that only the name of the person with the surname Zhang is displayed, and the rest is hidden.

If you want to display only the names of people with other surnames, you can do something similar by using the method described above.

If you want to find the name of a person with a certain surname among the many names that have been displayed, use the method.

In Excel, find the person's name and display it, the fastest and easiest way to understand the operation is to build an auxiliary column and combine the vlookup function to achieve, assuming the name data is in column A, enter the last name to be found in cell C2:

The first step is to create an auxiliary column in column b, enter the formula in b2 and pull it down to copy the formula, the purpose of which is to calculate the number of surnames;

In the second step, to display the list of last names in column d, enter the formula in d2 and pull down to copy the formula to complete the formula.

At this time, enter the last name to be queried in cell C2, then all the names of the last name will be displayed in column D. This method has fast computing power for big data, which is faster and more convenient than array surname operation

Finding a person's name is ctrl+f, and you can have fun.

Here's how to find a name in excel:Operating Equipment: Lenovo Legion Y700.

Device system: Windows 7.

Operating software: excel2016.

1. Open the Excel** that needs to be operated, find the item "Ruler Car" in the "Start" tab, and click "Find and Replace".

2. Select "Find" in the pop-up options.

3. Enter the name you want to find in the input box after "Find Content", and then click "Find All".

4. It can be found that the content of the entered name Ling Liangxi has been found.

5. Return to excel**, find that the name you are looking for is in the state of mouse selection, and the name search in excel is completed.

1. The left and right are two columns of ID number and corresponding name columns, the right column is a summary table, and the left column is less name and corresponding ID number, now you need to see which people are missing.

2. Enter =vlookup() in cell C2, the parentheses should be in the English parentheses, and then click the left mouse button inside the parentheses to make the cursor flash inside the parentheses.

3. After the cursor flashes in parentheses, click the A2 cell with the left mouse button, which is the first parameter of the function obtained by clicking the method, that is, the search value.

4. After clicking on the A2 cell, enter a comma, which is required to be a comma in English, and then use the left mouse button to select the data in the right ID number and name column, the function is to obtain the second parameter of the function, that is, the number orange suspect table, and the function will find the first parameter in the leftmost column of the data table.

5. After that, enter a comma in the English state, then enter 2, then enter the comma in the English state, and then enter 0, the function of 2 is to return the value in the second column of the number on the left side of the data table, 0 represents the exact search.

6. Click the second parameter with the left mouse button and drag it to the other side, select the parameter and click the F4 key on the keyboard, so that the dollar sign appears in front of the row label and column label of the parameter, in order to fix the function parameter.

7. Then tap the rightmost position of the function so that the cursor flashes there, and then tap Enter or click the check sign pointed by the arrow.

8. At this time, the return value of this function has appeared in the cell, but you can still see all the formulas in the column, and click the left mouse button in the lower right corner of the cell to double-click or pull down to complete the downward copy of the function.

9. Copy the result of this column function and optionally paste it as a numeric value, and then replace the wrong circle and thick hand error value in the return value with a null value.

10. At this time, you can see that some cells that were originally wrong are displayed as blank, and they are sorted in ascending or descending order in this column.

11. The red box in the blank area represents that the ID number column on the left lacks ID number information and cannot be found, so here is the wrong value, and now it is a blank value, and the blank in the green box means that there is no ID number in the left column in the right ID card column, that is, there is no ID number in the right column, and the ID number and the corresponding name in the left column, if the name is displayed normally, it means that there are both left and right sides.

The name is not unique, but the ID number is unique. Are you sure it's your name and ID number? Shouldn't it be the ID number to find the name?

Device: Lenovo computer.

System: win8

Software: Excel2016

1. First open an excel**, click on the search and select in the upper right corner of excel**.

2. In the pop-up interface, you can see many options for finding and selecting, click the first one, that is, search.

3. In this way, you have entered the search interface of excel, and in the search bar, you can see the input box of the content you are looking for.

4. Enter the name of the person you want to find in the following interface, and click Find All in the lower right corner.

5. In this way, you can find all the places where the person's name appears in the excel**. Click Find Next to view them in turn.

1. First of all, let's open an excel**.

2. Then, let's click on the bridge at the top right of excel** to find and select, as follows.

3. After entering the name of the person we want to find in the following interface, click Find All at the bottom right.

4. In this way, we can find all the places where the person's name appears in the excel**. Click on the lead digging to find the next one to view them in turn.

5. Of course, we can also quickly look up a person's name by pressing CRTL+F.

In excel, if you want to fill in the data according to the name automatically, how to achieve it, here is the operation method.

1. First open Excel**, enter "=vlookup" in the blank cell that needs to match the data and call the function.

2. Then select the name field you want to match.

3. After the comma separates, select the data range to match.

4. Separated by commas in English, enter data.

The number of columns in the range that need to match the extracted data.

5. Then select Exact Match.

6. Press Enter.

, it can automatically match the corresponding collapse resistance data by name.

7. Chang Pei Yuan finally pulls down, and Zhongshen can match the data corresponding to each name, and if there is no corresponding data, it will be displayed as n a, and it is completed.

Most of the answers on the Internet are achieved using formulas, which is more complicated, and here is a relatively simple method!

First ctrl+a select all**, then select Kai Hao sort, and finally ctrl+f search for the name of the person with the same name.

If you can't change the order of your request, you can make a copy of it and do it in the comma copy file.

First, select all the ** data.

2. Select Sort in ascending order.

Third, at this time, ** has been sorted.