COMPARE TEXT
=IF(AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH( "Closed",B3))),"True","False")
"CC" wrote:
I need find a way to compare two cells this way
example
Cell A3 Content = UV2345ZC
Cell B3 Content = System closed
The result in Cell C3 should be True if Cell A3 contain "ZC" and Cell
B3 contain "Closed"
|