Compare two lists of data to find new entries

G

Guest

I currently run a daily report from a CRM database to monitor my sales teams
activities with customers. Each activity has a 'unique' reference.
My aim is to compare the report (which is in excel) from one day with the
new report to show the new 'activities'.
In simple terms I want to say if activity 'x' is in the new list the show
the information from that row on a new worksheet so I can see at a glance the
new activities.
 
D

Dave Peterson

How about an alternative?

Insert a new column near that unique reference (say column B is inserted and
column A is the unique reference).

Then in B2 (Row 1 has headers???), put this formula:

=isnumber(match(a2,sheet2!a:a,0))

and drag down.

You'll end up with True's if there's a matching reference and False for no
match.

Then apply data|filter|autofilter to that range--you can show the True/False as
you please.
 

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

compare two lists 3
Display a weekending date even if there is no data 5
matching data from 3 different sources 4
Date Comparisons 4
Compare workbooks 11
Compare Groups of Data to Track Performance 5
Compare two worksheets and identify common entries 3
Compare two spreadsheets to find differences. 1

Top