| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like operator as a worksheet-function
Thank you!
"Chip Pearson" schrieb im Newsbeitrag ... Tom, You can't do it that way. However, you can use the * and ? wildcard characters in a COUNTIF, so try something like =IF(COUNTIF(B1,"??/???"),TRUE,FALSE) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Daniel I'd like to make a worksheet function like this: =If(B1 Like "##/###", True, False) Tom "Daniel.M" schrieb im Newsbeitrag ... Hi Tom, The Search() function enables you to do this. It is using a limited number of metacharacters: * and ? Regards, Daniel M. "Tom" wrote in message ... Hi Is it possible to use the Like operator as a worksheet-function? Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "IN Operator" using Match function.... | Excel Worksheet Functions | |||
| How to use a cell value as operator in a worksheet reference? | Excel Worksheet Functions | |||
| hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
| Excel's range Union operator in WORKDAY function gives #VALUE!. | Excel Programming | |||
| Method? Function? Operator? I dunno ): | Excel Programming | |||
Threaded Mode
