| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search vs find vs countif
I am trying to find a text string within a text field column in a large
spreadsheet. I've discovered that =COUNTIF(A1,"*abc*") does not work if the starting position of the text is 300 =SEARCH("abc",A1) and =FIND("abc",A1) both seem to work fine. The spreadsheet is big and slow so I'd like to pick the most efficient choice, but am also wondering what the difference between the 2 options are. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf and Search | Excel Discussion (Misc queries) | |||
| =IF(COUNTIF to search several groups of cells | Excel Discussion (Misc queries) | |||
| Can COUNTIF be nested to search two ranges | Excel Worksheet Functions | |||
| Using COUNTIF to search for existence | Excel Worksheet Functions | |||
| Can Search find 2 or more "/"? | Excel Discussion (Misc queries) | |||
Threaded Mode
