Hi Mike

Thanks:-)
works perfect

Cheers

On 8 Jun., 14:43, Mike H wrote:
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



"Leon" wrote:
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- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -