How to Compare two files

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
 
J

Joe

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Modern equivalent of Autotext in Word? 0
How to break up a book's endnotes by chapter in a file containing a whole book? 0
Merging from an Excel file with graphics 1
New computer, how do i move outlook 365 ENTIRELY? 0
Copy/paste in based on duplicate value in previous row 0
Comparing two spreadsheets 2
comparing two worksheets 1

Top