Help on comparing two data on two worksheet

[kphan78]

Hi guys
I have two large data includes numbers and character (.txt files).
I was just wondering what is the best way to compare those two data and
list out any changes between the two files.
Appreciated

Thanks

Kenny email : (e-mail address removed)

 

[Tom Ogilvy]

open each in excel in separate sheets.

insert column A in each

label the cells to indicate the source (fileA or fileB as an example)

Make a copy of the first sheet.

select the data from the second and paste below

sort this sheet using whatever columns would make sense.

examine for differences.