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!