Matching Name Fields in Two Columns

[chcalissie]

I'm trying to match two columns of names to determine what names in Col A/B are not in Col C/D and vice versa. I need to come up with the list of those in A/B that are not in C/D and those in C/D that are not in A/B. One person suggested concatenating the first and last name columns. But, after that, I'm not sure what to do.

I've attached an example.

Any help is appreciated.