What version of Excel are you using?
For an entire column, (65,536 or 1,048,576 rows) using Excel's built-in
functions are pretty much out of the question. My machine locks up when I
try this on more than 50,000 rows of data.
Download and install the free Morefunc.xll add-in from:
http://xcell05.free.fr/morefunc/english/index.htm
Alternative download site:
http://www.download.com/Morefunc/300...-10423159.html
Then use the COUNTDIFF function. However, this function won't accept an
entire column as a range reference. So, you'd have to set the range to one
less cell:
A1:A65535
A2:A65536
Also, see the help on COUNTDIFF since it has a few options as to
exclusions.
This function calculates very fast compared to a formula using buit-in
functions.
--
Biff
Microsoft Excel MVP
"Brian" wrote in message
...
Howdy All,
I have a formula:
=Sum(IF(Frequency(Match(A1:A14000,A1:A14000,0),Mat ch(A1:A14000,A1:A14000,0))0,1))
Which will give me a count if the unique values in the in column A, Rows 1
through 14000.
What I need is a formula I can use to count the unique values in and
entire Column, A:A. The above formula does not seem to allow that.
Any ideas are greatly appreciated.
Thanks,
Brian