Automatically identifying new data from old data after updating

[PZaro]

Hello everyone,

I'm just an average Excel user and I've run into a problem that I'm not sure how to go about solving. Hopefully I get some advice here.

We use IHS data to help us in finding business opportunities. Basically, you run a quick search on their site that sort of filters it. Then you can export the data to Excel. This usually gives us a spreadsheet of over 800 rows and about 40 columns. We like to retrieve this information quarterly. The problem is that pretty much every time you get the information, there are new programs (rows) but it's hard to tell which are the new ones.

So, is there a way to single out the new rows that appear with every time we update it? Like having it show up on a separate sheet or being shown in a different format? Would it possibly be better to use another program like Access?

Any advice at all is appreciated. Thanks

[RudiS]

Welcome to the forum

When you run the import a second time, does it bring in all the data of the previous run, including new data?
If so, the new data will be unique and the others will be duplicated.

You can use Conditional formatting to identify the unique values.
Select a single column (or the list) and from thew Home ribbon choose Conditional formatting, Highlight Cell Rules, Duplicate Values...and in the dialog that appears, choose Unique from the drop down.