| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Different Values in a column
I need to know the number of differing entries in a column.
For Example Name: George Carol Don George Don Carol Pat Sam George Should return 5 because there are 5 different names. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Different Values in a column
=SUMPRODUCT((A2:A200<"")/COUNTIF(A2:A200,A2:A200&""))
-- __________________________________ HTH Bob "KJ MAN" wrote in message ... I need to know the number of differing entries in a column. For Example Name: George Carol Don George Don Carol Pat Sam George Should return 5 because there are 5 different names. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Different Values in a column
If the values are in the range A1:A10 then
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) The first part gives 1 for each cell that is not empty. Then divides it with how many instances there is of this value. Summing that gives you the "unique count". The &"" is to avoid 0 and #DIV/0 when a cell is empty. Ref: http://www.mrexcel.com/archive2/63500/73502.htm Happy Programming! - Suranthe *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count values in column only if value of another column is true | Excel Worksheet Functions | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
![KJ MAN[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
