as the title says, I'm trying to compare the data in 2 different Excel spreadhseets.
Basically we have 2 mailing lists which are in spreadsheet format. What's happened is 1 spreadsheet has been update by one group of people and the other by another group of people.
I want to compare the 2 and then compile a new list based on the data from the existing spreadsheets minus the duplicates of course.
Thanks in advance,