Count Unique Items Using a function

[John]

Hello All,

Let's say I have a column of integers with a value
anywhere between 1 and 200. I would like to use a function
that will tell me how many unique integers are in the
column. I could probably write some sort of a function
which returns the unique count, but I was hoping there was
a more clever function for doing so.

Thanks in advance.

[immanuel]

Check out:

http://www.cpearson.com/excel/duplicat.htm#CountingUnique

/i.

"John" <anon...@discussions.microsoft.com> wrote in message
news:092801c3a79c$455745b0$a601...@phx.gbl...

[J.E. McGimpsey]

One way:

=SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&""))

In article <092801c3a79c$455745b0$a601...@phx.gbl>,

[Peo Sjoblom]

One way

=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

if there can be blanks

=SUM(IF(A1:A100<>"",1/COUNTIF(A1:A100,A1:A100)))

the latter entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

"John" <anon...@discussions.microsoft.com> wrote in message
news:092801c3a79c$455745b0$a601...@phx.gbl...

[Peo Sjoblom]

I like that null string at the end..

--

Regards,

Peo Sjoblom

"J.E. McGimpsey" <jemcg...@mvps.org> wrote in message
news:jemcgimpsey-9C4E...@msnews.microsoft.com...

[John]

Perfect, thanks.

>.
>