count of different type records

[Gábor]

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

 

[David Billigmeier]

Assume your range is A1:A10:

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))

 

[Gábor]

great! thanks a lot!

Assume your range is A1:A10:

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))