Enter this in B1
=COUNTIF(A1:$A$5,A1)
adjust $A$5 to your actual range
Copy it down
Then use
=SUMIF(B1:B5,1) to get the sum

"Fiona" wrote:

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