| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count text entries
How do I count unique text entries in a column and populate new cells w/the
count of each? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| count entries | Excel Worksheet Functions | |||
| Count unique entries... | Excel Worksheet Functions | |||
| count cells that contain text entries | Excel Worksheet Functions | |||
| count entries within a row | Excel Worksheet Functions | |||
Linear Mode
