| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF according to presence of string within text
I have 2700 rows where one of the columns is a description of an instrument. As you can imagine, the sky is the limit with the way the descriptions are written. Using the Auto-Filter feature, I can filter the cells in this column according to whether they contain or not-contain any text I choose. But then I have to count the rows returned. What I am looking for is to count the cells that contain a word or combination of words within a longer string of text. Is there a way to use COUNTIF based on any of the contents of a cell? Thanks! Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=507326 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text string and sum | Excel Worksheet Functions | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
| Extracting from a text string | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
Threaded Mode
