EXACT function

  • Thread starter Thread starter chrisrowe_cr
  • Start date Start date
C

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?
 
Back
Top