compare 2columes of name

Please is there a way I can compare two columns of names and getting a true
or false response in the third column, the downside is that the names in each
column are a combination of first, middle and last names that have been
concatenated together (These comparison are in thousands). Help please. thanks

E.G
column 1 column 2
John M James Doug S Smith
Mike j john kate Johnson
Hans Kible Lilly T Hanson

MikeH
Fri May 09 15:45:01 CDT 2008

From your posted data what would you expect to see for each case in column 3?

Mike

"Yossy" wrote:

> Please is there a way I can compare two columns of names and getting a true
> or false response in the third column, the downside is that the names in each
> column are a combination of first, middle and last names that have been
> concatenated together (These comparison are in thousands). Help please. thanks
>
> E.G
> column 1 column 2
> John M James Doug S Smith
> Mike j john kate Johnson
> Hans Kible Lilly T Hanson

PCLIVE
Fri May 09 15:49:05 CDT 2008

Do you want a true if the name appears only in the same row....or anywhere
in the column?

Only in same row:
=A1=A2

Anywhere in the column.
=IF(COUNTIF(A:A,B1)=0,FALSE,TRUE)

HTH,
Paul

--

"Yossy" <Yossy@discussions.microsoft.com> wrote in message
news:E1B59A77-4A67-4C21-B95C-6841FD860C5A@microsoft.com...
> Please is there a way I can compare two columns of names and getting a
> true
> or false response in the third column, the downside is that the names in
> each
> column are a combination of first, middle and last names that have been
> concatenated together (These comparison are in thousands). Help please.
> thanks
>
> E.G
> column 1 column 2
> John M James Doug S Smith
> Mike j john kate Johnson
> Hans Kible Lilly T Hanson

Yossy
Fri May 09 15:54:00 CDT 2008

Each column name has respective ID. So I want to see their id which is on the
respective next column to the names. Also I wouldn't know if it is better to
compare without the name concatenate(using each last name, middle and last
name seperately).
Thanks so much for your help

"Mike H" wrote:

> From your posted data what would you expect to see for each case in column 3?
>
> Mike
>
> "Yossy" wrote:
>
> > Please is there a way I can compare two columns of names and getting a true
> > or false response in the third column, the downside is that the names in each
> > column are a combination of first, middle and last names that have been
> > concatenated together (These comparison are in thousands). Help please. thanks
> >
> > E.G
> > column 1 column 2
> > John M James Doug S Smith
> > Mike j john kate Johnson
> > Hans Kible Lilly T Hanson

Yossy
Fri May 09 16:08:01 CDT 2008

PCLIVE Thanks,
I prefer the second one Anywhere in the column
=IF(COUNTIF(A:A,B1)=0,FALSE,TRUE). However i do not understand the range.
The A:A looks at the names in column A and compares with what? Also what does
the B1 do. I tried this but didn't get any comparison.

"PCLIVE" wrote:

> Do you want a true if the name appears only in the same row....or anywhere
> in the column?
>
> Only in same row:
> =A1=A2
>
> Anywhere in the column.
> =IF(COUNTIF(A:A,B1)=0,FALSE,TRUE)
>
> HTH,
> Paul
>
> --
>
> "Yossy" <Yossy@discussions.microsoft.com> wrote in message
> news:E1B59A77-4A67-4C21-B95C-6841FD860C5A@microsoft.com...
> > Please is there a way I can compare two columns of names and getting a
> > true
> > or false response in the third column, the downside is that the names in
> > each
> > column are a combination of first, middle and last names that have been
> > concatenated together (These comparison are in thousands). Help please.
> > thanks
> >
> > E.G
> > column 1 column 2
> > John M James Doug S Smith
> > Mike j john kate Johnson
> > Hans Kible Lilly T Hanson
>
>
>

PCLIVE
Fri May 09 16:29:06 CDT 2008

This assumes that your first column of names is column A. Your second
column of names is Column B (assuming). Place the formula in C1 and copy
down. If the value in B1 is found anywhere in column A, then it returns
TRUE, else it returns FALSE. If your data starts in a different other than
row 1, then adjust the formula as necessary.



--

"Yossy" <Yossy@discussions.microsoft.com> wrote in message
news:1C6E16CE-1789-4A7E-AD48-A6D4A7F5ECF2@microsoft.com...
> PCLIVE Thanks,
> I prefer the second one Anywhere in the column
> =IF(COUNTIF(A:A,B1)=0,FALSE,TRUE). However i do not understand the range.
> The A:A looks at the names in column A and compares with what? Also what
> does
> the B1 do. I tried this but didn't get any comparison.
>
> "PCLIVE" wrote:
>
>> Do you want a true if the name appears only in the same row....or
>> anywhere
>> in the column?
>>
>> Only in same row:
>> =A1=A2
>>
>> Anywhere in the column.
>> =IF(COUNTIF(A:A,B1)=0,FALSE,TRUE)
>>
>> HTH,
>> Paul
>>
>> --
>>
>> "Yossy" <Yossy@discussions.microsoft.com> wrote in message
>> news:E1B59A77-4A67-4C21-B95C-6841FD860C5A@microsoft.com...
>> > Please is there a way I can compare two columns of names and getting a
>> > true
>> > or false response in the third column, the downside is that the names
>> > in
>> > each
>> > column are a combination of first, middle and last names that have been
>> > concatenated together (These comparison are in thousands). Help please.
>> > thanks
>> >
>> > E.G
>> > column 1 column 2
>> > John M James Doug S Smith
>> > Mike j john kate Johnson
>> > Hans Kible Lilly T Hanson
>>
>>
>>