View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Garry Garry is offline
external usenet poster
 
Posts: 15
Default using exact formula to compare cells

I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when
the cells contain the same information. It just returns a FALSE answer.
--
Garry