How do I count a row of NON-duplicate entries in Excell?

I'm using Excell. I have a row of numbers, some of which repeat. I want to
count how many unique numbers I have, thus eliminating duplicates. What
formula and criteria do I use?

Ex: 2 34 5 26 77 8 91 42 3 26 1 77 50 26
In the above example, the correct answer should be 11
since I want to count 26 and 77 only once.

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

--
HTH

Bob Phillips

"needhelp" <[email protected]> wrote in message
news:[email protected]...
> I'm using Excell. I have a row of numbers, some of which repeat. I want to
> count how many unique numbers I have, thus eliminating duplicates. What
> formula and criteria do I use?
>
> Ex: 2 34 5 26 77 8 91 42 3 26 1 77 50 26
> In the above example, the correct answer should be 11
> since I want to count 26 and 77 only once.