How can I have excel tell me what string appears most in a column?

[Guest]

I have a column of alpha numeric strings and I want excel to be able to find
which strings appear most frequently. The column is several hundred cells/
rows long and each cell contains as many as 15 or so strings. Is there a way
to do this as an easily repeatable process in excel?

 

[Ron Rosenfeld]

I have a column of alpha numeric strings and I want excel to be able to find
which strings appear most frequently. The column is several hundred cells/
rows long and each cell contains as many as 15 or so strings. Is there a way
to do this as an easily repeatable process in excel?

Can you give a short example of the actual data and your expected output?


--ron