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?

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?

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?

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?

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 -