count of different type records

G

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
 
D

David Billigmeier

Assume your range is A1:A10:

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