How do I compare similar data in two separate workbooks?

G

Guest

I have my original workbook with data and I receive a workbook with similar
data from an outside source. I currently print the second workbook page by
page and manually do an audit to compare the second source data to my
original data. How can I have excel compare the two separate workbook data?
Help please....
 
B

Bill Ridgeway

If the amount of data isn't too great -

Copy and paste the two sets of data to a new workbook (so they follow on).
This will keep your originals away from danger.

In a helper column add A and B respectively to identify the source.

In a further helper column put the formula =IF(A1=Z1,1,0) where column A and
Z contains the information to be compared. This can be refined with a
formula comparing more than one field.

Sort data on a field (type of data) common to both sets of data.

Copy and paste (values) the second helper column.

You will now have all the data together with a flag in the second helper
column to show where you may have a duplicate

This is a bit tedious but, especially where there is a lot of data will save
some printing out and manual comparison.

Hope this helps.

Perhaps some thought should be given to avoiding this problem??

Regards.

Bill Ridgeway
Computer Solutions

"Excel Workook Data Comparisons" <Excel Workook Data
(e-mail address removed)> wrote in message
news:[email protected]...
 

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

Top