Compare two lists with two variables

If I wanted to check that the Surname AND the Firstnames were the same
in each of four columns,
what changes would I make? Ideally I would wwish that the output was as
below:-

Column A Column B Column C Column D
Surname Forename Common entry Surname Common entry Forname

Wilson Bob Wilson
Bob



Jonah

Hi John,

How about this ARRAY formula (Ctrl+Shift+Enter):

=AND(A2:B2=C2:D2)

Regards,
KL


"John" <john.scott@vrigin.net> wrote in message
news:4323319D.83FF48D4@vrigin.net...
> If I wanted to check that the Surname AND the Firstnames were the same
> in each of four columns,
> what changes would I make? Ideally I would wwish that the output was as
> below:-
>
> Column A Column B Column C Column D
> Surname Forename Common entry Surname Common entry Forname
>
> Wilson Bob Wilson
> Bob
>
>
>
> Jonah
>

I am not sure what this tells me. Please can you explain the
(Ctrl+Shift+Enter) and where do I put the formula?

John
-----------------

KL wrote:

> Hi John,
>
> How about this ARRAY formula (Ctrl+Shift+Enter):
>
> =AND(A2:B2=C2:D2)
>
> Regards,
> KL
>
> "John" <john.scott@vrigin.net> wrote in message
> news:4323319D.83FF48D4@vrigin.net...
> > If I wanted to check that the Surname AND the Firstnames were the same
> > in each of four columns,
> > what changes would I make? Ideally I would wwish that the output was as
> > below:-
> >
> > Column A Column B Column C Column D
> > Surname Forename Common entry Surname Common entry Forname
> >
> > Wilson Bob Wilson
> > Bob
> >
> >
> >
> > Jonah
> >

This will give you TRUE if the pairs are identical and FALSE if they are
not. "Ctrl+Shift+Enter" hasn't more explanation than that it is necessary
with (some) array formulas (formulas that operate with arrays, not single
values).

Regards,
KL


"John" <john.scott@vrigin.net> wrote in message
news:43241592.9C75245A@vrigin.net...
>I am not sure what this tells me. Please can you explain the
> (Ctrl+Shift+Enter) and where do I put the formula?
>
> John
> -----------------
>
> KL wrote:
>
>> Hi John,
>>
>> How about this ARRAY formula (Ctrl+Shift+Enter):
>>
>> =AND(A2:B2=C2:D2)
>>
>> Regards,
>> KL
>>
>> "John" <john.scott@vrigin.net> wrote in message
>> news:4323319D.83FF48D4@vrigin.net...
>> > If I wanted to check that the Surname AND the Firstnames were the same
>> > in each of four columns,
>> > what changes would I make? Ideally I would wwish that the output was
>> > as
>> > below:-
>> >
>> > Column A Column B Column C Column D
>> > Surname Forename Common entry Surname Common entry
>> > Forname
>> >
>> > Wilson Bob Wilson
>> > Bob
>> >
>> >
>> >
>> > Jonah
>> >
>

Hi!

Try this:

=A2&B2=C2&D2

Biff

"John" <john.scott@vrigin.net> wrote in message
news:4323319D.83FF48D4@vrigin.net...
> If I wanted to check that the Surname AND the Firstnames were the same
> in each of four columns,
> what changes would I make? Ideally I would wwish that the output was as
> below:-
>
> Column A Column B Column C Column D
> Surname Forename Common entry Surname Common entry Forname
>
> Wilson Bob Wilson
> Bob
>
>
>
> Jonah
>