How to classify different content in excel

How to classify different content in excel: first click to open the table that needs to be classified and summarized; then customize the sorting according to the department, click on the classified summary, the field is the department, and the sum is the quantity; finally, the summary of the classification is obtained Result form.

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

How to classify different content in excel:

First, we open a form, and you can see that the form contains a lot of personnel information, and different people belong to different department.

Now, we select all the personnel information and then select custom sorting.

In custom sorting, we select departments and arrange them in descending or ascending order.

Then select the sorted data and click on the summary in the outline display.

In the pop-up window, we select the classification field as department, the summary as quantity, and then classify.

Finally, the classification results are obtained, and three tables show different classification situations.

Related learning recommendations: excel tutorial

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