EXACT function

[chrisrowe_cr]

Can you use the EXACT function on a range? The help says you can, but
I have been unable to get it working.

A1="burt"

B1="burt"

=Exact(A1,B1) = true

HOWEVER....

A1="burt"

B1="ernie"
B2="big bird"
B3="burt"

{=Exact(A1,B1:B3)} = false

Whats up with that?

 

[Gary Brown]

Try this:-

={OR(EXACT(A1,B1:B3))