Prev: delete duplicates
Next: Run a macro from another workbook in the QAT
From: T. Valko on 18 Mar 2010 16:47
I know!

--
Biff
Microsoft Excel MVP


"Mike H" <MikeH(a)discussions.microsoft.com> wrote in message
news:A9A74438-F1F5-4A6F-A8BF-803FF2686EFA(a)microsoft.com...
> He's behind you
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "T. Valko" wrote:
>
>> One way...
>>
>> =SUMPRODUCT((A2:A20<>"")/COUNTIF(A2:A20,A2:A20&""))
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Cassie" <Cassie(a)discussions.microsoft.com> wrote in message
>> news:B610A13C-FAF8-46EF-A63C-AAE88EEFB89F(a)microsoft.com...
>> > hi
>> > How do I count a list of names, some names appear more than once. I
>> > only
>> > want to count unique names.
>> > I use excel 2007
>> > Thanks
>> > Cassie
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: delete duplicates
Next: Run a macro from another workbook in the QAT