How to Compare two files

  • Thread starter Thread starter Applegate
  • Start date Start date
A

Applegate

Hi..

I have two files that I would like to compare for changes.
Both the files are sorted by customre number and I would
like to produce a new file (worksheet) which has data for
customer whose info (address phone number fax no etc) has
changed. Any suggestion..Please help
 
One option: Use the "EXACT" function to compare the
similar strings of text...
Internal to the formula use the "CONCATENATE" function to
string together the datavalues that you want to compare...
In this example A1,B1,C1 appear on Sheet1 and the
comparison text appears on Sheet2... the formula can be
anywhere else... this will work across worksheets or
across workbooks...

=EXACT(CONCATENATE(A1,B1,C1),CONCATENATE(Sheet2!A1,Sheet2!
B1,Sheet2!C1))
 
Back
Top