How do you find the most reoccurring name in a column?

[lovethemfires45]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)

I would like to know, how to find the most reoccurring name in a column. I know I can use "Mode" for numbers, but what about text?

 

[Carl Witthoft]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)

I would like to know, how to find the most reoccurring name in a column. I
know I can use "Mode" for numbers, but what about text?

If you've got a limited number of names, create a stack of cells with


=COUNTIF(a1:a100,"MIke"),
=COUNTIF(a1:a100,"Alice"),

etc.
Otherwise, it may be time for a different tool (bash, R, Ruby)