Excel Tutorial: How to count the number of different types in a column of data?

Tanabata romantic date "Hui"

Super Member Lifetime Card 23% off for a limited time

The original price is 168. Sign up today for only 129!

Don't miss it. ヾ(◍°∇°◍)ﾉﾞ

Starting from actual combat, aiming at solving problems. Hello everyone! I am very happy to learn Excel with my friends every day. Today, I will share with you how to count the number of unique data in the table. When it comes to unique data, I believe that everyone is familiar with it. In high-frequency data analysis, This type of problem is often encountered. However, there are many ways to solve the problem corresponding to this unique value, such as deleting duplicate values, formula statistics, pivot tables, or VBA dictionaries and so on.

Specifically, we need to choose which method to use to solve the problem according to the actual problem application scenario. For example, in the case demonstrated today, if the amount of data is relatively small, we can use the WPS form to open it, and directly filter the fields to expand to see the corresponding unique data. There are several numbers, and each field is also counted.

A friend said that his computer does not have WPS installed, what should I do? Don't panic, we can just use the software's own function of deleting duplicate values, first select the column data that needs to be counted, find the delete duplicate value in the data tab, and select execute. After the execution is successful, the software will prompt how many duplicates were found. value, how many position values are reserved, and then we can fill in the unique value in the corresponding cell.

If we do not destroy the data of the statistical column, we can use the array formula to count the data of unique values, for example, enter the formula in cell C2: {=SUMPRODUCT(1/COUNTIF(A2:A11,A2:A11)) }

It should be noted that the curly brackets on both sides of this array formula are not entered manually, but after the formula is entered, press the shortcut keys Ctrl+Shift+Enter to end the automatically generated array formula.

In addition to deleting duplicate values and formulas, we can also use the function of the pivot table to count the values, but the value of the pivot table statistics is very similar to the previous WPS filter count, but one is displayed in the filter state, and Pivot tables store the results in a table, and there are still some differences between the two.

That's all for today's sharing. If the tutorial is useful to you, I hope you will share and support the editor! Every like and repost of yours is the motivation to support the editor to insist on originality.

Why choose us, the platform advantage is there

Advantage ①: VIP can learn all tutorials, unlimited learning + supporting material source files + unlimited downloads

Advantage 2: Support WeChat public account + applet + APP + PC website for multi-platform learning

Advantage 3: Support offline viewing, double-speed viewing, allowing you to learn anytime, anywhere

Advantage ④: VIP logo, distinguished status + independent after-sales group answers

★ FAQ ★

①Xiao Ai: Can you watch all the courses after buying VIP ?

Well, yes, including future updates (thanks for your support, we will insist on high-quality teaching updates)

②Xiao Ai: Hello, how do you study ?

Pay attention to the Aizhiqu Education Service Account, you can directly enter the official website to learn from the menu navigation, or you can enter the applet and download the APP!

Computer login to https://www.92zhiqu.com

(Mobile phone, computer learning is essential)

③Xiao Ai: what to do if you do n’t understand

Provide after-sales answers, pay to contact customer service and join the group (pay to contact WeChat customer service, just take a screenshot)

④Xiao Ai: Provide video courseware materials ?

Well, original high-definition video, these are provided (original tutorial, these are the most basic requirements)

⑤Classmate Xiao Ai: Validity period of study ?

Annual membership and lifetime membership, unlimited lifetime membership (self-built website + original tutorial + Aichiqu brand guarantee)

⑥ Primary school students: Does the website support accelerated viewing ?

kindness. At present, mobile phone applet + APP + computer PC all support 1.5 times accelerated viewing or slow playback

⑦ Does the course support offline download ?

kindness. Both Android and Apple IOS APP support mobile phone offline download

Computer downloads are provided by contacting WeChat customer service 18074746783.

⑧ How about the quality of the course ?

Aizhiqu Education high-quality video as the starting point, high-definition subtitles, support for audition

If there is anything else you need to consult, please contact WeChat customer service 18074746783

Long press to identify the QR code "Add Customer Service"

Click to read the original text , log in to the official website with one click, and learn from a large number of video VIPs! (you can try it out)