Home >Topics >excel >How to filter count in excel

How to filter count in excel

尚
Original
2019-06-14 15:55:0524254browse

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

How to filter count in excel

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

How to filter count in excel

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

How to filter count in excel

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

How to filter count in excel

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

How to filter count in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn