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

--
Gary''s Student - gsnu200828


"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