Hi

i don't have any other ideas, do you want to email your workbook so i can
have a look? - send it direct to julied_ng at hcts dot net dot au - it's
11.38pm here so i probably won't get to it until tomorrow.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"TBoe" <TBoe@discussions.microsoft.com> wrote in message
news:414CD9C7-01DE-4C63-9BAD-714460B54369@microsoft.com...
> This is what I did Julie....
> Copied and pasted the formula into the formula bar and changed the cell
> coordinates
> then hit control, shift, enter. Thanks again.
>
> "JulieD" wrote:
>
>> Hi
>>
>> are you sure you're using control & shift & enter to enter the formula
>> and
>> not just enter
>> have you changed a1:a10 to your actual range?
>>
>> --
>> Cheers
>> JulieD
>> check out www.hcts.net.au/tipsandtricks.htm
>> ....well i'm working on it anyway
>> "TBoe" <TBoe@discussions.microsoft.com> wrote in message
>> news:30C3C5A1-9015-4102-8613-2B5E33A0C149@microsoft.com...
>> > Thanks much for your help Julie. Really appreceite it. I keep coming
>> > up
>> > with 0 as the total. There's probably about 15 different names. I'll
>> > work
>> > with that formula awile to see if it will solve this. I'm sure it's
>> > just
>> > me.
>> > Thanks again.
>> >
>> > Terry
>> >
>> > "JulieD" wrote:
>> >
>> >> 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" <TBoe@discussions.microsoft.com> wrote in message
>> >> news:4CDB588E-AC3D-41DD-AE1A-12442C54EA56@microsoft.com...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>