Excel classification summary

xiaoxiao2021-03-13  201

First click on "Model" (classified by this column), the result is as follows, then select this two columns ("Model" as the classification column, "the number" is summary), as shown in the figure:

Select menu "Classification summary":

pop-up dialogue box:

After setting, click "OK", see the results:

(Figure 1)

(Figure II)

note:

1. You must first sort before the operation classification;

2

转载请注明原文地址:https://www.9cbs.com/read-129074.html

New Post(0)