|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
07-08-2006, 05:56 AM
|
|||
|
|||
|
Counting how many times specific character appears in range?
how can i count all the words in a range that are starting with a specific letter?
for e.g. i want to know how many words are starting with 'W' waj arw was The result should come out as "2" Please help 
|
|
#2
07-28-2006, 01:50 PM
|
|||
|
|||
|
try this,
=COUNTIF([data range],"w"&"*")
|
|
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
