Reputation: 1531
Let's say I have different text values in a column such as:
(source: sartodimoda.com)
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 -
(source: sartodimoda.com)
Thank you so much for your help.
Upvotes: 15
Views: 52291
Reputation: 59
I faced to the same problem a while ago, and the only way for me was a "Pivot Table", though adding such function in "SUBTOTALS" would be very handy:
Enjoy!
Upvotes: 5
Reputation: 1953
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)
Upvotes: 13