| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND function for an array
Following is the column data:
A 1 America 2 Britain 3 UAE 4 Saudia Do I have a choice to use an array formula using the FIND function to be placed in B1 so as to evaluate if there exists an "m" in any cell of the array A1:A4? Similarly, do I have a choice to use an array formula using the FIND function to be placed in B1 so as to evaluate if there exists an "a" in all the cells of the array A1:A4? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Find Function | Excel Discussion (Misc queries) | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Threaded Mode
