| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
Find a "9" within a range using a function (T/F)
Hi Harlan,
You know, I was trying to cobble together an array formula on my own before I decided I was not on the right track. At least I thought that an array formula would be the path of least resistance...just couldn't make it work. Thanks, Harlan !! Richard -- RMC,CPA "Harlan Grove" wrote in message oups.com... Biff wrote... .... =SUMPRODUCT(--(ISNUMBER(FIND("9",A1:B12))))0 .... If you're willing to put up with an array formula, =COUNT(FIND(9,range))0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| dynamic named range function | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
