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

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

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