| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SEARCH and arrays
Is there any way to use SEARCH with an array? Is there some other formula?
Here's the goal: cells D1 thru M1 have a text string. Cells A1 through A50 have text strings. Some of the items in D1:M1 may be substrings of items in A1:A50. I am trying to come up with a method to go through the list D1:M1 and tell me if any of the words are embedded in A1:A50. Make sense? all ideas appreciated Janie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Threaded Mode
