For convenience,list1(B5:B16) andlist2(D5:D12) arenamed ranges.
Also notice that there are 4 zeros in the array.A zero value indicates a name inlist1thatwas notfound inlist2.
The 1’s in the array indicate a name inlist1thatwasfound inlist2.
Any non-zero number becomes FALSE, and any zero value becomes TRUE.
This is what we need to report the missing names.
If any data changes, FILTER will recalculate and return an updated list.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
When given TRUE, NOT returns FALSE.
When given FALSE, NOT returns TRUE.
Use the NOT function to reverse a logical value.
Related videos
How to find missing values with COUNTIF
FILTER function basic example
