| Home |
| Search |
| Today's Posts |
|
#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 *** |
| 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 | |||
Threaded Mode
