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" <ragdyer@cutoutmsn.com> wrote in message
news:u44lMilSFHA.3156@TK2MSFTNGP15.phx.gbl...
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" <billmorgan@discussions.microsoft.com> wrote in message
news:C8CBAAA9-A658-475A-8343-F8242E211802@microsoft.com...
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