How to count the number of the same names in excel

After opening the excel table, select the data content you want to count, and click [Pivot Table] in the data ribbon area

According to the actual situation, select the location of the data source cell and the location of the counted data

Check the items you want to count to complete the setting of data statistics.

The result is as shown:

Recommended related tutorials: excel tutorial

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