removing data that doesn't appear in another spreadsheet with a common dataset

Hi.

I've got two different spreadsheets (On my mac) that have data sets arranged in rows.

The sheets have one common column, "column 10" for simplicity, but "sheet A" has 5000 rows of data, and "sheet B" has 65.

How can I isolate the rows in "sheet A" that have the identical data in "column 10" as "sheet B" ?

1 Reply

I think you can use below formula to sort this:

https://exceljet.net/formulas/extract-common-values-from-two-lists