Hi

you can use the following array function (enter it with control & shift &
enter, not just enter):
=SUM(1/COUNTIF(A1:A10,A1:A10))

where your data is in the range A1:A10

check out http://www.cpearson.com/excel/duplicat.htm for more options and
details

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"TBoe" wrote in message
...
I have a column with people who contacted us during a given month. Some
times the same person 2 to 3 time during the month. What funtion would I
use
to count this list but only count duplicate names to = 1. Thank you.

1 Jim
2 stan
3 stan
4 bob
5 Jim
6 Scott

t = 4