I have two lists of names. I would like to compare each name in list2 to look for a match in list1. If there is no match, I would like to output the non-matching name in a third list.
Is there a simple array formula to do this?
Simple Example:
ColAA ColAB ColAC
LIST1 LIST2 LIST3
Adams Smith Jones
Smith Carver Montes
Jones Johnson Reali
Baker Baker
Johnson Adams
Montes
Reali
Carver
List1 may/may not be sorted in alpa order. Hopefully, there is a way to do this either (sorted/unsorted) way.
Thanks,
MD/
Is there a simple array formula to do this?
Simple Example:
ColAA ColAB ColAC
LIST1 LIST2 LIST3
Adams Smith Jones
Smith Carver Montes
Jones Johnson Reali
Baker Baker
Johnson Adams
Montes
Reali
Carver
List1 may/may not be sorted in alpa order. Hopefully, there is a way to do this either (sorted/unsorted) way.
Thanks,
MD/