Hi,

You can try this formula

SUMPRODUCT(1/COUNTIF(D4:D11,D4:D11)). Please adjust the range as per your
needs

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Annie" wrote in message
...
Hi
I have a column with a list of company names and people working in those
companies - but there are duplicate company names. Can I count the
companies
but not the duplicates - there are too many to do countif and I am using
2003
version of Excel. Is there a count non-duplicates function or something
like
that?

Thanks
--
Kind regards

Ann Shaw