find entries common in two lists

parky_pilot Find common entries, then what?

(1) Do you want to highlight commons?

(2) Do you want list separate common lists?

(3) Just want to mark TRUE/FALSE or Yes/No? or something else?

To highlight common items use-

=COUNTIFS($G$2:$G$7,$A2)>0

To separate lists, use-

=FILTER(A2:A7,COUNTIFS(G2:G7,A2:A7))

To mark as TRUE/FALSE, use-

=ISNUMBER(XMATCH(A2:A7,G2:G7,0))

Download the attached file to see more...