How to count the number and number of duplicate items in excel

Method: First select the table, click "Data" - "Pivot Table" at the top of the page; then click "Existing Worksheet" and select a blank area in the table; then in "Pivot Table" Check the "items" that need to be counted and drag them to the "row"; finally click "Sum Item" - "Value Field Settings" - "Count" and click "OK".

The operating environment of this tutorial: Windows 7 system, WPS Office version 11.1.0.10314, Dell G3 computer.

Open the excel document in WPS, select the table, and click Data-Pivot Table.

On the Create Pivot Table page, click on the existing worksheet, select a blank area in the table, and click [OK].

After creation, check the [Item] grades that need to be counted in the pivot table on the right and drag them to the [Row] box.

Click the summation item under [Value]-Value field settings.

Click Count-OK in the Value field settings.

Statistics successful.

Related learning recommendations: excel tutorial

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