Comparing data (Before & After)

[Guest]

I have set up two tabs within a worksheet with some data I want to compare.
The first is entitled "Before" and the second "After". On the third tab
(called "Comparison") I want to write a query of some type that looks at the
data on the "Before" tab and the data on the "After" tab. If the information
is the same, it leaves the cell blank on the "Comparison" tab; if the
information is different, it inserts a statement that says "Data does not
match".

Since I'm new to comparing data in Excel (I have 51,000 lines of data that
was imported from two .TXT files) is there a quick and easy way to do this?

Thanks.

 

[Trevor Shuttleworth]

Put:

=IF(Sheet1!A1=Sheet2!A1,"","different")

in cell A1 on your Comparison sheet. Then copy down and across to cover all
the cells you want to compare.

Well, that's one (simple) way. Use AutoFill to make it quicker.

Regards

Trevor