Count function
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 |
Count function
=SUMPRODUCT(--(A1:A20&""<"")/COUNTIF(A1:A20,A1:A20&""))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
Count function
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 |
Count function
Thanks
"Bob Phillips" wrote: =SUMPRODUCT(--(A1:A20&""<"")/COUNTIF(A1:A20,A1:A20&"")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
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 |
All times are GMT +1. The time now is 11:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com