How can I compare and filter data in 2 spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula to compare two worksheets and create a new spreadsheet
without duplicates and with the new data in it? Can it be done?
 
Try copying all the data from both worksheets to a new single worksheet and
then use the advanced filter to copy the unique records only to a new
location.

In xl2007 click on Data to obtain the correct Ribbon and you will see
Advanced under sort and filter. In earlier versions select
Data->Filter->Advanced Filter and you will see the options to copy to another
location, the box for copy to location and check the unique records box.

Hope this helps.

Regards,

OssieMac
 
I guess I should explain what I am trying to do. I pull a report every day of
the week of the same type of data. I need to find the new and deleted record
between the two days. I have tried the filter, but unless I am doing
something wrong, it doesn't give me both.
 
You must log in or register to reply here.

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

comparing columns in two spreadsheets 1
finding duplicate addresses across 2 worksheets in the same workbo 2
Compare data (2 columns) from 2 worksheets within a workbook 2
Comparison of columns using Conditional Formatting 3
Duplicate image in Excel spreadsheet 2
Comparing info on 2 spreadsheets 1
Comparing two spreadsheets 2
Compare data in two worksheets 1

Back
Top