One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ,rng),0))

Note: In cases where two or more types occur with equal, maximum
frequency, the first one in the list will be returned.


In article ,
maluli wrote:

I have a range of unit types and I want to count each unit type and return
the one that occurs most often.