RagDyeR,

This works...! Not sure how, yet, but I am working on that. Thanks so much
for your reply.

"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