Difference Report

A

Al

How can I create a report that will compare and report the difference between to two worksheets?
 
J

jeff

Hi,

You can use a third worksheet. past into A1:

=IF(Sheet2!A1<>Sheet3!A1,Sheet2!A1 & "**" & Sheet3!A1,"")

and copy down and across.

This would show blank cells where match, and the two
values together when they differ.

jeff
-----Original Message-----
How can I create a report that will compare and report
Click to expand...
the difference between to two worksheets?
 
Top