Skip to content

“A left semi-join returns only the rows from the left table…” — Learn Microsoft Excel with MyExcelOnline at 35:39

“A left semi-join returns only the rows from the left table where there are one or more matching rows in the right table. It's like a quick filter. You get just the data from the left table that has a corresponding match on the right. A common use case might be identifying customers with recent purchases. Think about…”

0:00 39:37