#Excel - 计算列中某个元素的出现次数 [英] #Excel - Count the number of occurrences of an element in a column
本文介绍了#Excel - 计算列中某个元素的出现次数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想知道如何计算列中个别元素的发生次数。
例如,我有一个单列
颜色
红色
红色
蓝色
红色
绿色
橙色
蓝色
绿色
我想输出一个单独的列,如
3
蓝色 - 2
绿色 - 2
橙色 - 1
解决方案
数据透视表是要走的路。
选择所有行与您的数据。转到插入 - >数据透视表。
选择要输出表格的位置
I would like to know how do you count the number of occurrence of individual elements in a column.
Eg, I have a single column
Colors
Red
Red
Blue
Red
Green
Orange
Blue
Green
I want the output in a separate column like,
Red - 3
Blue - 2
Green - 2
Orange - 1
I tried CountIf, didn't work that great for me. Tried using Pivot Table, I didn't know how to choose the rows to be K. I'm dealing with more than 100k rows, please help. :) Thank you!
解决方案
Pivot table is the way to go.
select all the rows with your data. Go to Insert --> Pivot Table.
Choose where you want to output the table
You want put the Colors
in both Rows and Values.
这篇关于#Excel - 计算列中某个元素的出现次数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文