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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbimauh - 27 Apr 2004 02:13 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 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!

Reply to this Message

David McRitchie - 27 Apr 2004 02:40 GMT

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

> 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
[quoted text clipped - 6 lines]
> Excel Templates, Training, Add-ins & Business Software Galore!
> Free Excel Forum http://www.ozgrid.com/forum ***

Reply to this Message