Assuming your company names are in A1:A100, this array* formula will
count the unique names:

=SUM(IF(LEN(A1:A100),1/COUNTIF(A1:A100,A1:A100)))

Assumes a data range of A1 to A100 - adjust as necessary.

*An array formula needs to be committed using the key combination of
Ctrl-Shift-Enter (CSE) rather than the usual Enter. If you do this
correctly then Excel will wrap curly braces around that formula when
viewed in the formula bar - do not type these yourself. If you edit/
amend the formula you need to use CSE again.

Hope this helps.

Pete


On Jan 30, 1:09*pm, 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