How many unique items (count) ?
=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10&""))
If there are blanks in the range they count as an item
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
blanks are note included in count
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fiona" wrote in message
...
Hi
Does anyone know how I can count numbers in a list, but only count the
one's
that are different, for example, if counting the following:-
12345
12345
23569
12358
22583

I only want to show a total of 4...

Also, can this be applied to text?

thankyou