Comparing two ranges and get true or false in one cell depending onresult

[Leon]

Hi all

How do I compare two alike ranges with one formula and get result as
true or false.
Ranges are alike = true
Not alike = false

Cheers

 

[Mike H]

Hi,

Try this Array formula

=AND(A1:A10=B1:B10)


This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

 

[Gaffnr]

Hi LEon
Use the exact formula

i.e. Col A = Animal 1, Col B = Animal 2
A2 = Dog, B2 = Dog. formula in C2 = exact(A2,B2) returns true
If A2 = Cat then C2 would return false.

 

[Leon]

Hi Mike

Thanks
works perfect

Cheers

Hi,

Try this Array formula

=AND(A1:A10=B1:B10)

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike







- Vis tekst i anførselstegn -