I am using Google Sheets to track changes in a group's roster. Cells B2:B240 contain the old list of names, and C2:C240 contains the new list. Both lists are alphabetized. There is a lot of overlap between the two lists, so I want to identify new members (i.e. present in C but not in B) using the QUERY tool. I did find a way to check for differences on an individual row level, but that method is inconvenient for my spreadsheet layout.
Here is a sample spreadsheet: https://docs.google.com/spreadsheets/d/1e7bEZtcmwEKvEef795sAam3lv3CMu6MlqyhHiTWr214/edit?usp=sharing
Essentially, I want column D to list all the names that are in C but not B. That will give me a list of all the players who joined, and I can use the same logic to find those who left (i.e. in B but not C). Column D in the sample has this formula:
=query(B2:C240, "select C where C<>B")
It gives me the first unique entry, but also lists all the other entries where B and C don't match up because of the offset.