| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search / Find Function
I would like Excel to count all my NY customers; e.g., Search("NY",B2) if
the state code NY is found in a lengthy text field containing a name, address, comma separators, etc. The search works fine if NY is in the searched cell, but returns #Value if not. I can't perform any logical function on the result if it returns #Value. How do I get around that? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find / Search Function | Excel Discussion (Misc queries) | |||
| IF with Search/Find??? | Excel Worksheet Functions | |||
| Find & Search Function | Excel Worksheet Functions | |||
| Can Search find 2 or more "/"? | Excel Discussion (Misc queries) | |||
| HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions | |||
Threaded Mode
