| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checking for a string & No.
Hi,
I have a col and i need to check for a text in a cell and i required the count. EX : ABC 115 DEF 245 ADD 515 FAC 576 So here i want to know how many cell contains "A". I required the count. Answer is 3 same way in Nos. col i required how many cell contains "5". Answer is 4 Can any one help me to get it. I can do it in filters == custom == contains == but i need it by formula. -Christ. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
| Checking for the existence of a characted in a string | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
![Christopher Naveen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
