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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: bbimauh (bbimauh_at_yahoo.com)
Date: 04/27/04 

Date: 27 Apr 2004 01:13:04 GMT

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 work*** within the spread*** 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 ***

Quantcast