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

From: David McRitchie (dmcritchie_at_msn.com)
Date: 04/27/04 

Date: Mon, 26 Apr 2004 21:40:20 -0400

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 

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
"bbimauh" <bbimauh@yahoo.com> wrote in message news:408db3a0$0$198$75868355@news.frii.net...
> 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 ***