Thread
:
If a cell contains a certain value
View Single Post
#
2
Posted to microsoft.public.excel.misc
Keith74
external usenet poster
Posts: 120
If a cell contains a certain value
Hi
This seems to work, someone else might have a better solution
=IF(ISERROR(SEARCH("GLOBAL",A1) ) = TRUE,0,1)
hth
Keith
Reply With Quote
Keith74
View Public Profile
Find all posts by Keith74