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?
--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile:
http://www.excelforum.com/member.php...o&userid=25220
View this thread:
http://www.excelforum.com/showthread...hreadid=390163