| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| row count function | Charts and Charting in Excel | |||
| COUNT Function | New Users to Excel | |||
| Count function | Excel Discussion (Misc queries) | |||
| using the count function | Excel Discussion (Misc queries) | |||
| count function | Excel Worksheet Functions | |||
Linear Mode
