| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two lists of data to find new entries
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
| compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Threaded Mode
