Excel公式 - 计算列中文本值的频率 [英] Excel Formula - Count the frequency of text values in a column
问题描述
列A http://www.sartodimoda.com/columna.jpg
我想要一个公式来计算列中每个文本值的频率。所以答案应该显示在两列中。列D应该是文本值,列E应该是出现的频率 - 所以应该出现这样的东西 -
立柱D& E http://www.sartodimoda.com/columnde.jpg
非常感谢您的帮助。
正如@Kabir在评论中所说,你可以使用一个数据透视表。您也可以使用 COUNTIF
函数。尝试将以下公式放在单元格E1中并向下拖动,以便列D中的其他单元格。
= COUNTIF(A:A ,D1)
Let's say I have different text values in a column such as:
Column A http://www.sartodimoda.com/columna.jpg
I want a formula to calculate the frequency of every text value in the column. So the answer should be displayed in two columns. Column D should be the text value and column E should be the frequency of occurrence - so it should come out something like this -
Column D & E http://www.sartodimoda.com/columnde.jpg
Thank you so much for your help.
As @Kabir said in the comments, you could use a pivot table. You could also use the COUNTIF
function. Try putting the following formula in cell E1 and dragging it downward so the other cells in column D.
=COUNTIF(A:A,D1)
这篇关于Excel公式 - 计算列中文本值的频率的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!