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))