Excel q: Display most frequently occuring text string in a column

Factual Questions
1

Hey guys

So, I have a spreadsheet and in column J I have a group of 3 character codes. Looks like:

JVD
VKR
JVD
VOR
PPL
OKR
JVD
…

I want to put a formula in another cell that displays the most frequently occuring string in column J. I don’t know if Excel (2007) has a built-in way to do this, but if someone could walk me through the process, I’d appreciate it!

2

I’m no Excel expert, but i found this. The second response has a sample spreadsheet you can work from.

Is this what you were looking for?