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?

Try this in A1:

=COUNTIF(C:C,"xyz")>0

Hope this helps.

Pete

On Jun 28, 11:47 pm, "D.P. Roberts" <DProbe...@pbride.com> 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?

=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?
>
>
>

That is perfect - thanks!

"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try this in A1:
>
> =COUNTIF(C:C,"xyz")>0
>
> Hope this helps.
>
> Pete
>
> On Jun 28, 11:47 pm, "D.P. Roberts" <DProbe...@pbride.com> 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?
>
>

Glad to be of help - thanks for feeding back.

Pete

On Jul 19, 9:56 pm, "D.P. Roberts" <DProbe...@pbride.com> wrote:
> That is perfect - thanks!
>
> "Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > Try this in A1:
>
> > =COUNTIF(C:C,"xyz")>0
>
> > Hope this helps.
>
> > Pete
>
> > On Jun 28, 11:47 pm, "D.P. Roberts" <DProbe...@pbride.com> 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 -