Thread: Comparing a value to a list of values does not work in Excel 2003.
View Single Post
  #2   Report Post  
Shawn K.
 
Posts: n/a
Default Comparing a value to a list of values does not work in Excel 2003.
Very strange, the following simple formula is not working...
=OR(EXACT(A1, D1:D10))

it does not go through the range.... and compare

Thanks.
Shawn
Reply With QuoteReply With Quote