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.

--
Rob Gaffney


"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