Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find a "9" within a range using a function (T/F)
I need to try to cobble together a function nest or whatever I have to do, which will tell me if the number 9 exists anywhere within
a range of cells. The 9 could be just one character of a larger number (i.e. 1496), or it could be just a nine. I know that I could use filtering or use the find feature with the dialog box, but I need a formula instead. Also, I just need to know a true or false; I don't need to know where the nine is or any other info. I just need to know if it is there. I'm stumped. Any ideas? Thanks in advance! -- RMC,CPA |
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 |