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

L

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
 
M

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
 
G

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.
 
L

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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top