Contains function

[Guest]

I'm trying to determine if data in one cell is contained in another cell. In the following example I would like to see if A1 is in B1 then "True" else "False". Is there any easy way to do this? Thanks!

A B
1 Baez CN=Oscar Baez/OU=US/O=ABCDEFGH/C=NL True
2 Bailey CN=Eleanor Bailey/OU=US/O=ABCDEFGH/C=NL True
3 Smith CN=Makisha Baines/OU=US/O=ABCDEFGH/C=NL False
4 Jones CN=Karen Bajda/OU=US/O=ABCDEFGH/C=NL False
5 Baker CN=LeeAnn Baker/OU=US/O=ABCDEFGH/C=NL True

 

[Dave R.]

Heres 1 way;

=+IF(COUNTIF(B1,"*"&A1&"*")=1,"TRUE")

I don't see exactly where your columns are setup, but if A contains names
"Baez","Bailey", etc. then this will find any occurence of that name in
column B. If it occurs, "True", if not, FALSE.

I'm trying to determine if data in one cell is contained in another cell.

In the following example I would like to see if A1 is in B1 then "True" else
"False". Is there any easy way to do this? Thanks!

 

[Jason Morin]

One way:

=ISNUMBER(SEARCH(A1,B1))

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm trying to determine if data in one cell is contained

in another cell. In the following example I would like to
see if A1 is in B1 then "True" else "False". Is there any
easy way to do this? Thanks!

 

[Jim]

One way: Concatenate the pertinent cells; lets say you use Column F to
concatenate.

=COUNTIF($F$2:$F$1500,F2)>1

Fill the formula down to the end of your data. TRUE will be returned for
duplicates, FALSE otherwise. Adjust for your actual data range.


--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

I'm trying to determine if data in one cell is contained in another cell.

In the following example I would like to see if A1 is in B1 then "True" else
"False". Is there any easy way to do this? Thanks!