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

Try this:-

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


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=390163