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