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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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