Comparing 2 tables with similar content

[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

[Niek Otten]

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

--
Kind regards,

Niek Otten

"Vic1978" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

[Peo Sjoblom]

Use

=A2>1


--

Regards,

Peo Sjoblom


"Vic1978" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Niek Otten]

Hi Vicky,

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

--
Kind regards,

Niek Otten

"Vic1978" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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