Hi Everyone,

I am hoping for a helping hand relating to my last task.

I have two spreadsheets.
Each spreadsheet has a long list of names. The information is all in one column, and each cell in that column has "First Name Last Name".

I would like to compare one list to the other and find out where one Spreadsheet contains names that are not in the other other Spreadsheet. I would like these non-matching names highlighted.
Each Spreadsheet starts with a different name and ends with a different name.
One Spreadsheet has 1500 names. The other has 1200 names.
The two spreadsheets are not that similar.

Is there an easy way to compare them to highlight the non-matching names?

I can copy the spreadhseets in to the same document as separate sheets, if that helps.

Thank you
R