| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a formula to 'find' word in cells of column from a long l
Very good!
-- Biff Microsoft Excel MVP "Jai" wrote in message ... Never mind, figured it out. For those interested =IFERROR(INDEX($A:$A,SMALL(IF(ISNUMBER(SEARCH(TRIM ($B1),$A$1:$A$500)),ROW($A$1:$A$500),""),?)),"") entred as an array where ? is the number of the result. So the first column giving the first match would have ?=1, the second column giving the second match would have ?=2, etc enjoy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Long list, 2 criteria, find unique, paste | Excel Discussion (Misc queries) | |||
| Find a group of names in a long list | Excel Discussion (Misc queries) | |||
| how do you keep fields in a column to print out for long list | Setting up and Configuration of Excel | |||
| Long list of words to find with Filter | Excel Discussion (Misc queries) | |||
| Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
Threaded Mode
