G Guest Jun 3, 2004 #1 How can I create a report that will compare and report the difference between to two worksheets?
J jeff Jun 3, 2004 #2 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?
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?
D Dave Peterson Jun 4, 2004 #3 A program by Myrna Larson and and Bill Manville kept on Chip Pearson's site: http://www.cpearson.com/excel/whatsnew.htm look for compare.xla It compares A1 to A1, B99 to B99...
A program by Myrna Larson and and Bill Manville kept on Chip Pearson's site: http://www.cpearson.com/excel/whatsnew.htm look for compare.xla It compares A1 to A1, B99 to B99...
