Count function
thanks,
"Peo Sjoblom" wrote:
Assume the values are in A1:A10
=SUMPRODUCT(--(A1:A10<""),1/COUNTIF(A1:A10,A1:A10&""))
--
Regards,
Peo Sjoblom
"orquidea" wrote in message
...
HI
I have a list of series like this
serie 165125
serie 165126
serie 165127
serie 165125
serie 165126
serie 165124
serie 165125
I want to count how many series I have. The formula have to consider that
some series are repeiting in many rows. ei in the list above will be 4
series.
Could anyone help me please.
Thanks,
Orquidea
|