Tips & Tricks 207 – Common Across Two Columns

Following formulas can be used to find common entries across 2 columns

=TOCOL(XLOOKUP(A2:A9,B2:B9,B2:B9), 2)

=FILTER(A2:A9, COUNTIF(B2:B9, A2:A9))

=FILTER(A2:A9, IFNA(XMATCH(A2:A9,B2:B9),))

Sample File – T&T_207