Count string in each text cell of a column

[ashley12]

Hi everyone,

I'm given an excel sheet to analyze. There is a text column and people used checked boxes to enter the data. So many cell ended up with many text strings in them, like this: "String1String2String3". And I have to get the most occurring string in the whole column.

Do you have any suggestion on how to achieve this?

Thanks

 

[diddi]

if the checkboxes are still on the sheet, it would be easier to count them assuming they were placed in a logical order when the survey was designed. otherwise you will need a big list of every string and then pick them out, which causes problems with duplicates

 

[ashley12]

Hi Diddi, how do I pick the strings out? There are not too many of them, just a lot of entries. I can't count the checkboxes because they were used in the form to fill in the data, but the data is in a table now.