| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count unique text
Is there a function, or good way,to count unique text in a list? For
example, I would like an answer of 3 from the text in the list below: Dog Cat Dog Bird Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count unique text
Assume your range is A1:A10:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) -- Regards, Dave "shzdug" wrote: Is there a function, or good way,to count unique text in a list? For example, I would like an answer of 3 from the text in the list below: Dog Cat Dog Bird Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count unique text
These will work too:
=SUM(IF(FREQUENCY(MATCH(A2:A11,A2:A11,0),MATCH(A2: A11,A2:A11,0))0,1)) =SUMPRODUCT((A2:A11<"")/(COUNTIF(A2:A11,A2:A11&""))) =SUMPRODUCT((A2:A11<"")/(COUNTIF(A2:A11,A2:A11)+(A2:A11=""))) =SUMPRODUCT(--(A2:A11<""),1/COUNTIF(A2:A11,A2:A11&"")) =SUM(IF(FREQUENCY(IF(LEN(A2:A11)0,MATCH(A2:A11,A2 :A11,0),""),IF(LEN(A2:A11)0,MATCH(A2:A11,A2:A11,0 ),""))0,1)) (Note: This is a CSE Function) Adjust all ranges to suit... -- RyGuy "David Billigmeier" wrote: Assume your range is A1:A10: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) -- Regards, Dave "shzdug" wrote: Is there a function, or good way,to count unique text in a list? For example, I would like an answer of 3 from the text in the list below: Dog Cat Dog Bird Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| count and display unique values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Linear Mode
