Comparing 2 tables with similar content

V

Vic1978

Hi,

I would like to know how it is possible to compare several sheets in
one file, which have similar content. I need a function who shows me
how to compare it and gives me the result in another sheet (same file)

How can I manage this?
Thanks a lot,
Vicky :)
 
V

Vic1978

Hello,

unfortunately this function doesn´t work. There is always an error...

What is wrong with the formula?

=(COUNTIF(A2;">1"),TRUE,FALSE)

Kind regards,
Vicky
 
N

Niek Otten

Hi Vicky,

That is not a formula from the link I gave. Please check the examples
carefully!
 
V

vezerid

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
 
Top