Say the list is in column H:

=SUMPRODUCT((H1:H1500<"")/COUNTIF(H1:H1500,H1:H1500&""))

adjust the range to suit your needs.
--
Gary''s Student - gsnu200829


"Annie" wrote:

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