Comparing 2 tables with similar content
 

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 :)


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=490744

Comparing 2 tables with similar content
 

http://www.cpearson.com/excel/duplic...tingDuplicates

--
Kind regards,

Niek Otten

"Vic1978" wrote in
message ...

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 :)


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=490744

Comparing 2 tables with similar content
 

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


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=490744

Comparing 2 tables with similar content
 

Use

=A21


--

Regards,

Peo Sjoblom


"Vic1978" wrote in
message ...

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


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=490744

Comparing 2 tables with similar content
 

Hi Vicky,

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

--
Kind regards,

Niek Otten

"Vic1978" wrote in
message ...

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


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=490744

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