EXACT function
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 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com