ITEMS_NOT_IN_LIST. It returns all the items from List1 that are not in List2.

 

 

 

 ITEMS_NOT_IN_LIST. It returns all the items from List1 that are not in List2.

LAMBDA(List1,List2, SORT(FILTER(List1,NOT(ISNUMBER(XMATCH(List1,List2))),"[None]")))