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

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?

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

On Thu, 26 Jan 2006 11:25:02 -0800, btsray
wrote:

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