Biff,

Not unusual for me these days, I'm being a bit slow!!

You're asking for the wrath of Bernd! <g

Why?

Mike

"T. Valko" wrote:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

You're asking for the wrath of Bernd! <g

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
Hi,

Try this with the range adjusted to suit

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Mike

"Meenie" wrote:

I have excel 2003
How can I create a formula that counts items in a column without counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't seem
to
come up even though other new questions have popped in.
thanks Meenie


.