How to automatically match the same names in excel

How to automatically match names with the same name in excel: first select the data in the name column; then click [Start-Edit-Sort and Filter-Custom Sort]; then the "Sort" window will pop up. In the main Select "Name" as the keyword; finally click [OK].

How to automatically match names with the same name in excel:

1. First, let’s briefly describe our problem. In the following table, we want to arrange the same name information in the name column together. How to deal with it?

2. Select the data in the name column. The selected mark is the thick black line of the table. After that, select: "Edit" on the "Home" tab. "Sort and Filter" - "Custom Sort".

3. At this time, the "Sort" window will pop up. Select "Name", "Sort by" and "Order" from the main keywords of the column to execute the default options. That’s it.

#4. After clicking the "OK" option, return to the Excel interface again, and you will find that the same information in the name column has been arranged together.

5. The editor will explain the underlying reasons for sorting. Follow the same method as above to enter the "Sort" window again and click "Options" at the top. See Excel sorting rules.

#6. By default, after you select the corresponding data, it will be sorted. The direction is "sort by column" and the method is " "Alphabetical sorting", under such rules, we can ensure that the same information in Excel will be arranged together.

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to automatically match the same names in excel. For more information, please follow other related articles on the PHP Chinese website!