software

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

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.
--
Excel Newbie

Put:

=IF(Sheet1!A1=Sheet2!A1,quot;quot;,quot;differentquot;)

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

Trevorquot;Excel Newbiequot; lt;someone@thebrinkgt; wrote in message
...
gt;I have set up two tabs within a worksheet with some data I want to compare.
gt; The first is entitled quot;Beforequot; and the second quot;Afterquot;. On the third tab
gt; (called quot;Comparisonquot;) I want to write a query of some type that looks at
gt; the
gt; data on the quot;Beforequot; tab and the data on the quot;Afterquot; tab. If the
gt; information
gt; is the same, it leaves the cell blank on the quot;Comparisonquot; tab; if the
gt; information is different, it inserts a statement that says quot;Data does not
gt; matchquot;.
gt;
gt; Since I'm new to comparing data in Excel (I have 51,000 lines of data that
gt; was imported from two .TXT files) is there a quick and easy way to do
gt; this?
gt;
gt; Thanks.
gt; --
gt; Excel Newbie