| 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 | |||
Hybrid Mode
