Performing a compare in Excel

[tuccokeith]

Hello,

I want to run a compare in Excel.

I have two lists.

The main list - Pricing contains master records

The second list - Offshore contains some of the master records plus additional records.

I want to run a report/compare that pulls out the unique records from the second list Offshore.

How can I use the advanced filter or other functionality to do this?

 

[Wray69]

Check out thread68-532642 thread68-532642 it discuss the same issue and give a couple of suggestions.

Regards,

Wray