How to filter and display the quantity of each item in excel

How to filter and display the quantities of various items in Excel: First open the form and enter data, click "Insert", and select "Pivot Table"; then click "Pivot Table" and select the fields to be added to the report below. Put a check mark before the name; finally, drag the name of the fruit you want to add to the report field with the mouse to the number box for counting.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to filter and display the quantities of various items in excel:

1. First, open the excel form and enter some data to facilitate the following processing. As shown below:

#2. Select the table, click "Insert" and select "Pivot Table". As shown in the picture:

3. Click "Pivot Table", select the new worksheet in the pop-up dialog box, and click OK, as shown below:

4. Check the box before selecting the name to be added to the report field. We can see that the row labels display unique fruit names, as shown in the figure:

5. Use the mouse to drag the fruit names you want to add to the report field to the number box for counting, and you can see the number of each fruit name. As shown in the picture below:

Related learning recommendations: excel tutorial

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