Counting the number of times a word appears in a worksheet

Jig Bhakta

Posts: n/a

Counting the number of times a word appears in a worksheet

Hi,

I want to have a formula in a cell that counts the number of time a certain
word appears in any cell in a worksheet. i've tried using count but it only
counts for numbers, not text.

Thanks,

Jignesh.

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
how do i link a number of worksheets to one master worksheet?	Rusty	Excel Worksheet Functions	0	January 24th 05 08:49 AM
Weekly Transaction Processing	Ralph Howarth	Excel Worksheet Functions	4	January 19th 05 05:37 AM
Inserting worksheet in Word	Connie Martin	Excel Discussion (Misc queries)	0	January 11th 05 06:19 PM
Whats the function to count the total times a word is displayed	Monk	Excel Discussion (Misc queries)	3	December 10th 04 10:39 PM
Can the number of times undo is used in Excel 2002 be increased?	Austrian Hannes	Setting up and Configuration of Excel	2	December 6th 04 05:54 PM

All times are GMT +1. The time now is 11:15 AM.

Menu

About Us