Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a formula, not VB code, to count the number of unique values in a column of up to 10,000 rows, some of which will be blank. The values may be numeric, alphanumberic, or text.
The twist is that the formula can't use either the SUMPRODUCT or the FREQUENCY functions. The excel handler which processes the file for a database can't handle SUMPRODUCT or FREQUENCY. I got very close with this array formula: =SUM(1/COUNTIF(A1:A36,A22:A36)) But as you can see it has to be limited to the range of nonblank cells, since it throws a #DIV/0 error if the range includes blank cells. I've made some unsuccessful attempts at using COUNTIFS with criteria for only nonblank cells. Any ideas? Thanks in advance! pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for counting frequency then sorting | Excel Worksheet Functions | |||
Counting the number of unique values within a range | Excel Discussion (Misc queries) | |||
Counting Unique Values by Date Range | Excel Worksheet Functions | |||
Counting unique values + frequency | Excel Worksheet Functions | |||
Counting Unique Entries Wit a Twist | Excel Programming |