Posted to microsoft.public.excel.misc

ALEX

external usenet poster

Posts: 493

counting

I'd like to know if you can count words inside of a cell that are separated
by a comma. For example, if i have N,S inside of a cell, I'd want a count of
2. If i had NA,S - i would still want a count of 2. NA,S,C - i would want a
count of 3. Please let me know if this is possible and how.

Thank you
Alex

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 If	Neil Pearce	Excel Discussion (Misc queries)	1	February 11th 08 03:03 PM
counting function but not double counting duplicates	JRD	Excel Worksheet Functions	2	November 7th 07 06:43 PM
Counting	AdamMCW	Excel Worksheet Functions	4	September 7th 06 11:58 AM
Counting rows, then counting values.	Michael via OfficeKB.com	Excel Discussion (Misc queries)	7	August 4th 05 10:57 PM
Counting names in a column but counting duplicate names once	TBoe	Excel Discussion (Misc queries)	9	May 11th 05 11:24 PM

All times are GMT +1. The time now is 11:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us