count text entries
 

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

count text entries
 

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

--
RyGuy


"pja" wrote:

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

count text entries
 

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...

"ryguy7272" wrote:

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

--
RyGuy


"pja" wrote:

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

count text entries
 

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.

"pja" wrote:

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...

count text entries
 

=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

On Fri, 2 May 2008 12:36:01 -0700, pja wrote:

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...

"ryguy7272" wrote:

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

--
RyGuy


"pja" wrote:

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