| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can IF do this?
I'd like to have a function in cell A1 that does the following:
If Column C contains the text string "xyz" in any of its cells, display "true"; if not, display "false" Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can IF do this?
Try this in A1:
=COUNTIF(C:C,"xyz")0 Hope this helps. Pete On Jun 28, 11:47 pm, "D.P. Roberts" wrote: I'd like to have a function in cell A1 that does the following: If Column C contains the text string "xyz" in any of its cells, display "true"; if not, display "false" Is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can IF do this?
=ISNUMBER(MATCH("xyz",C:C,0))
"D.P. Roberts" wrote: I'd like to have a function in cell A1 that does the following: If Column C contains the text string "xyz" in any of its cells, display "true"; if not, display "false" Is this possible? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can IF do this?
That is perfect - thanks!
"Pete_UK" wrote in message oups.com... Try this in A1: =COUNTIF(C:C,"xyz")0 Hope this helps. Pete On Jun 28, 11:47 pm, "D.P. Roberts" wrote: I'd like to have a function in cell A1 that does the following: If Column C contains the text string "xyz" in any of its cells, display "true"; if not, display "false" Is this possible? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can IF do this?
Glad to be of help - thanks for feeding back.
Pete On Jul 19, 9:56 pm, "D.P. Roberts" wrote: That is perfect - thanks! "Pete_UK" wrote in message oups.com... Try this in A1: =COUNTIF(C:C,"xyz")0 Hope this helps. Pete On Jun 28, 11:47 pm, "D.P. Roberts" wrote: I'd like to have a function in cell A1 that does the following: If Column C contains the text string "xyz" in any of its cells, display "true"; if not, display "false" Is this possible?- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
