Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPARE TEXT
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPARE TEXT
=AND(RIGHT(A3,2)="ZC",RIGHT(B3,6)="Closed")
"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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPARE TEXT
One way:
=AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH("Cl osed",B3))) HTH, Paul "CC" wrote in message ... 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" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPARE TEXT
=AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH("Cl osed",B3)))
If you want the searches to be case-sensitive, then replace SEARCH() by FIND(). -- David Biddulph "CC" wrote in message ... 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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare & match text | Excel Worksheet Functions | |||
using IF statement to compare text | Excel Worksheet Functions | |||
Text Compare Function | Excel Worksheet Functions | |||
How do you compare text in cells | Excel Worksheet Functions |