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