#Excel - 计算列中某个元素的出现次数 [英] #Excel - Count the number of occurrences of an element in a column

问题描述

我想知道如何计算列中个别元素的发生次数。

例如，我有一个单列

颜色

 红色
红色
蓝色
红色
绿色
橙色
蓝色
绿色
  

我想输出一个单独的列，如

  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屋！