Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like operator as a worksheet-function
Hi
Is it possible to use the Like operator as a worksheet-function? Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like operator as a worksheet-function
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like operator as a worksheet-function
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like operator as a worksheet-function
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 |
#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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like operator as a worksheet-function
"Tom" wrote...
Is it possible to use the Like operator as a worksheet-function? Not unless you wrap it in a UDF. See http://www.google.com/groups?selm=uP...icros oft.com -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
Reply |
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 |