I have two spreadsheets that contain one column of city names. One spreadsheet contains city names that are currently in my database and the other contains some new names and some that may already be in my database. I need to find only those city names that are new. Assume that my columns are Column A - City Name Column B- Source ("New List" or "Old List"), how do I pick up only those city names that I do not yet have? Would this be through a pivot table? If so, what exactly would I do?
Thanks
Bookmarks