I have a Google Sheet where I have five columns and 20 rows of names, and I am looking for a way to collect all the names, sort them, and list them in a single column, then compare the list against another list to find the missing names.
I searched for an example of how to accomplish this and found nothing similar. :(
To be specific, I need to find a way to do this using a formula and without add-ons macros. Is it possible?
To make this easier, I am including a working sheet:
Here is the example sheet