count text entries

[pja]

How do I count unique text entries in a column and populate new cells w/the
count of each?

 

[ryguy7272]

Any of these functions will allow you to count uniques:
=SUMPRODUCT((A2:A78<>"")/(COUNTIF(A2:A78,A2:A78&"")))
=SUMPRODUCT((A2:A78<>"")/(COUNTIF(A2:A78,A2:A78)+(A2:A78="")))
=SUM(IF(FREQUENCY(IF(LEN(A2:A971)>0,MATCH(A2:A971,A2:A971,0),""),IF(LEN(A2:A971)>0,MATCH(A2:A971,A2:A971,0),""))>0,1))
(this last one is a CES function; ctrl + shift + enter...not just enter)

I'm not sure what you mean by 'populate new cells'. Can you elaborate?

Regards,
Ryan---

 

[pja]

Thank you for your quick response...I have a column of data (e.g., n2:n10)
that includes 'a' , 'b' and 'c' in it...I would like to count each instance
of each of a,b and c...and send the answer to three other cells....thanks
again...

 

[Dave]

Hi,
Select a cell to show how many a's, and insert:
=COUNTIF(N2:N10,"a")
Use for b and c by changing the "a" for "b" etc
Dave.

 

[Gord Dibben]

=COUNTIF(N2:N10,"a") in a cell

=COUNTIF(N2:N10,"b") in a cell

=COUNTIF(N2:N10,"C") in a cell


Gord Dibben MS Excel MVP