| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to seacrh for a word across multiple columns
Hi, I have four columns of data (C-F) I need to search for a particular word.
The data is addresses, i.e. it combines text and numbers and the word I'm searching for can appear anywhere within it (or not at all). The function I require will return 1 if it does and 0 if it does not. Have tried various iterations of if\search\match and so on to no avail - perhaps because I'm searching a range of columns rather than a specific cell? I'd appreciate your suggestions. Regards, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using lookup function on multiple rows and columns | Excel Worksheet Functions | |||
| Using count function for multiple columns | Excel Worksheet Functions | |||
| Vlookup Function with Multiple Reference Columns | Excel Worksheet Functions | |||
| how do i reference multiple rows/columns with one function? | New Users to Excel | |||
| how do i reference multiple rows/columns with one function? | New Users to Excel | |||
Threaded Mode
