Posted to microsoft.public.excel.newusers

Bad_Shot[_2_] Bad_Shot[_2_] is offline

external usenet poster

Posts: 16

Counting text

I am trying to count the number of rows where specific text strings appear.
If I found "jim" count it likewise, if I had "jack,jim" or "jim,john" count
them as well, etc.

A
1 jim
2 jack
3 jim
4 jack, jim
5 jim, john
6 Jack, john

I'd like the answer to be, in this case 4.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text Counting	TYTQ	Excel Worksheet Functions	1	November 23rd 08 08:19 AM
Counting a mixed text/number column based on text in another colum	Sierra Vista Steve	Excel Discussion (Misc queries)	3	December 17th 06 05:30 PM
Text Counting	krs1040	Excel Discussion (Misc queries)	3	July 26th 06 12:22 AM
counting text	dknibbe	Excel Worksheet Functions	1	November 7th 05 08:52 PM
Counting Occurrence of Text within Text in Cells in Range.	Jeremy N.	Excel Worksheet Functions	1	September 8th 05 05:16 AM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us