Count unique names in a list
in [General]
|
From: Cassie on 18 Mar 2010 13:30 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
From: T. Valko on 18 Mar 2010 13:39 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
From: Brad Vogt on 18 Mar 2010 13:42 For range of B1:B20. =SUMPRODUCT((B1:B20<>"")/COUNTIF(B1:B20,B1:B10&"")) "Cassie" wrote: > 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
From: Cassie on 18 Mar 2010 13:46 Brad Thanks this works fine What would the formula be if I also needed to count all the unique names by month. The months are in col c. the names appear multiple times in the file at least once in each month - I only want to count John Smith once in January but his name appears 4 times. Cassie "Brad Vogt" wrote: > For range of B1:B20. > > =SUMPRODUCT((B1:B20<>"")/COUNTIF(B1:B20,B1:B10&"")) > > > "Cassie" wrote: > > > 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
From: Mike H on 18 Mar 2010 14:58
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 > > > . > |