Paul

Correct. Does work with blanks it the range. My bad.

Gord

On Thu, 3 Feb 2005 08:55:49 -0500, "Paul B"
wrote:

Gord, sorry did not check it on text, but it looks like it does work over a
range with blank cells, on numerics.

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Paul

This is the second time you have posted this formula in two days.

Have you tried it on any column of data other than numerics?

Returns 0 for me and the Help states it won't work on blanks or text
cells.

Frito

Suggest you look at Chip Pearson's site......

http://www.cpearson.com/excel/duplic...CountingUnique


Gord Dibben Excel MVP

On Wed, 2 Feb 2005 15:53:58 -0500, "Paul B"

wrote:

Here is one way,

=COUNT(IF(FREQUENCY(A:A,A:A),1))