fantastic
"RagDyeR" wrote:
For some reason, the end of the formula was cut off.
Try this:
=SUMPRODUCT((A1:A30000<"")/COUNTIF(A1:A30000,A1:A30000&""))
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------
"RagDyeR" wrote in message
...
Try this:
=SUMPRODUCT((A1:A30000<"")/COUNTIF(A1:A30000,A1:A30000
With this formula, you *cannot* use an entire column as a reference (A:A).
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
&""))
"bill_morgan" wrote in message
...
The sheet contains 30,000 rows. I need to determine the number of distinct
(unique) values in column A. What is the most efficient way to do this in
Excel?
For example, I can pull the data into Access and use a select query to
"group by" column A to get the answer. But I need to get the answer within
Excel.
Thanks for your help ...
Bill Morgan
|