| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count of different type records
hi,
are there any way to count that how many different type of records are in a column? for example, in column A are 6 times a210, 8 times a240 and 3 times g450. in this case i have three types of record, but i have a little bit bigger database and i would like to know how many types of record are in it. i wonder that there could be something like countif or else but i have no idea at the moment thx in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count of different type records
Assume your range is A1:A10:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) -- Regards, Dave "Gábor" wrote: hi, are there any way to count that how many different type of records are in a column? for example, in column A are 6 times a210, 8 times a240 and 3 times g450. in this case i have three types of record, but i have a little bit bigger database and i would like to know how many types of record are in it. i wonder that there could be something like countif or else but i have no idea at the moment thx in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count of different type records
great! thanks a lot!
"David Billigmeier" wrote: Assume your range is A1:A10: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) -- Regards, Dave "Gábor" wrote: hi, are there any way to count that how many different type of records are in a column? for example, in column A are 6 times a210, 8 times a240 and 3 times g450. in this case i have three types of record, but i have a little bit bigger database and i would like to know how many types of record are in it. i wonder that there could be something like countif or else but i have no idea at the moment thx in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique records... with a twist... Need help! | Excel Worksheet Functions | |||
| Need formula to count spinoffs | Excel Worksheet Functions | |||
| count of records with 2 or more "options" selected | Excel Worksheet Functions | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
Hybrid Mode
