search of a string in a cell and counting occurences using COUNTIF

[bbimauh]

i need to separate out items which are in a column with cells containing
1 or more of these items delimited by commas. i need to export them to
another worksheet within the spreadsheet which lists down the items
individually per cell and then, i need to count the occurences. i tried
to use the asterisk i.e. '*cell_contents*' in the countif formula but i
get an error. please help!

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[David McRitchie]

To whom it may concern,
I do not know what your question actually is.

To separate a column on a delimiter you can select the
column and use Data, Text to Columns to use the same
wizard as the Text Import Wizard.

Much beyond that you've lost me. You might also take a look
at one of John Walkenbach's pages.
Tip 52:Cell Counting Techniques
http://www.j-walk.com/ss/excel/tips/tip52.htm