Count Instances of Text in String Q

Posted to microsoft.public.excel.worksheet.functions

Sean

external usenet poster

Posts: 454

Count Instances of Text in String Q

How could I formulate a formula that will count the number of times a
cell value appears within a text string in non contiguous range.

Example A1 contains the value "Tue". I wish to add the number of times
A1 appears in ranges B5;B8;B14;Bk15.

The actual text in B5;B8;B14;Bk15. will be "No Sales for Tue"

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
Count Multiple Instances of Text in a Cell	CLR	Excel Discussion (Misc queries)	0	January 4th 08 07:56 PM
Count Multiple Instances of Text in a Cell	Dave Peterson	Excel Discussion (Misc queries)	0	January 4th 08 07:53 PM
Count Multiple Instances of Text in a Cell	JE McGimpsey	Excel Discussion (Misc queries)	0	January 4th 08 07:45 PM
Countif function for instances of text string contained	Garbunkel	Excel Worksheet Functions	1	October 11th 05 08:09 AM
Countif function for instances of text string contained	David Billigmeier	Excel Worksheet Functions	2	October 10th 05 09:51 PM

All times are GMT +1. The time now is 05:14 AM.

Menu

About Us