Posted to microsoft.public.excel.worksheet.functions

Chris the researcher Chris the researcher is offline

external usenet poster

Posts: 1

Counting number of occurances of a word

I need to count the number of times a word shows up in a given cell for which
the number will then show up below the name of the word.

ex. B1
[Jon]
A3 ? How many times did
Jon appear?
[Jon, Kate, Jon, Lilly]

I want excel to put in a number where the ? is.

Please help!

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
counting occurances	neilb514	New Users to Excel	1	September 3rd 08 06:57 PM
Counting 7 and 8 occurances	[email protected]	Excel Discussion (Misc queries)	2	May 9th 07 02:59 AM
Counting Occurances	Rusty	Excel Discussion (Misc queries)	5	July 10th 06 08:29 PM
counting occurances	SR89	Excel Worksheet Functions	6	June 28th 06 01:46 AM
count number of occurances of a word in a range	John Davies	Excel Worksheet Functions	3	February 24th 06 01:46 PM

All times are GMT +1. The time now is 09:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us