View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Comparing 2 tables with similar content

Vicky,
regardless of the other members' suggestions, the specific formula as
you type it:
=(COUNTIF(A2;"1"),TRUE,FALSE)
will not work. Either you will use comma or semicolon in all arguments.
Furthermore, in this case you forgot the IF.
=IF(COUNTIF(A2,"1"),TRUE,FALSE)

HTH
Kostis Vezerides