How to filter count in excel

Open the data table, select the data to be counted, click "Insert", click "Pivot Table", then a page will appear, click "New Worksheet", and then click "OK", in the new table, check the field names on the right, and then unique data will appear on the left. Drag the checked fields into the "Value" box to count each data. How many times each appears in the original table.

The specific steps are as follows:

1. Open the data table, select the data to be counted, click "Insert", and click "Pivot Table", as shown below

2. Then a page will appear. Click "New Worksheet" and then click "OK", as shown below

3. In the new In the table, check the field name "One Unit Production" on the right, and then there will be unique data on the left, as shown in the figure

4. Change "One Unit Production" Drag "Partial Production" into the "Value" box to count how many times each data appears in the original table, as shown below

5. At this time, The number of occurrences of each data is automatically given in the table, as shown in the figure

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

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