Compare 2 worksheets in Excel 2010

[swdodd]

Have a question about comparing worksheets in Excel 2010.


Here is a simple scenario.


Sheet 1 has 10 rows of data

Sheet 2 has the same 10 rows of data but there are two additional for a total of 12 rows.


Is there a formula in Excel that will compare the 2 worksheets and highlight the differences?


I know that there are VBA and 3rd party scripts that will do it but am wondering if there is something native to Excel 2010 that will do the same thing.

 

[kchiba]

Hi,


How do you identify the difference?

 

[kchiba]

Hi,


You can use Conditional Format with a formula like =MATCH(A2,Sheet4!$A$1:$A$10,0) and set the colour accordingly

 

[SirJB7]

Hi, swdodd!

Adding my two-cents to what kchiba posted, the CF formula should be:

=A1<>COINCIDIR(A1;Sheet1!A$1:A$10;0) -----> in english: =A1<>MATCH(A1,Sheet1!A$1:A$10,0)

And should be applied to whole range of fulfilled columns in second sheet.

Regards!

 

[swdodd]

Thanks for the help. I'll give that a try.