There are times when the statistical work is particularly cumbersome, if the amount of data is small, simple screening can also be completed accordingly. When the data is very large, it is difficult to rely solely on manual screening to complete the task accurately and in a timely manner.

For example, in the face of a complex array of data, the need to organize all the data frequency, and will be categorized according to how many times each item appeared in descending order in order to organize the chart is a very difficult thing. Then good use of EXCEL with or without determining the efficiency of a person's work. The following introduces a method that can be effectively sifted from a complex and chaotic data in all categories, and to be sorted, the formation of charts.

If you need to count the large amount of data in the text of the C column. Select the text in column C, click Data --- Remove Duplicates. That is, you can get all the non-repeating categorized text. For the convenience of subsequent operations, it is recommended that in the first step of the operation to remove duplicates, the C column will be copied to the A column or any column you want to copy, and then carry out the first step of the operation.

Copy to column A as an example. After coming up with non-duplicated categorized text in column A, you can start counting the number of times each categorized text appears in the original text.

In order to subsequently generate the chart, the bad items screened out in column A are pasted and copied to item D. (Note: do not copy directly from column D to item D.) (Note: The reason for not doing the first step directly in D is to prevent confusion when reusing this text later, so it is recommended that the first step be done in column A.)

With the countif function to start counting the number of times each of the non-repeating items selected in the first step in the original text where the C column. In E2, enter the formula = countif (column C, D2), then you can count the number of times the D2 item appears in column C. Drag down, then you can count the number of times each text appears in the original text.

3.1 The above figure is the result after it has been sorted. Generally the filtered data is randomized. Select columns D and E, point to Data - Sort, the following dialog box will appear.

3.2 Click Add Condition, according to the text in the following figure set.

3.3 Click OK, the selected text will be sorted in descending order.

Select columns D and E, and then insert the chart, you can form a histogram in descending order.

So, complicated and large data can be done in a few minutes. And this kind of text can be utilized repeatedly, very convenient and fast. You can go out and eat and drink while others are still searching for different types of items.