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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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


--ron
 
Back
Top