| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
