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
|