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

Question

Hi.&nbsp; &nbsp;I've got two different spreadsheets (On my mac) that have data sets arranged in rows.&nbsp;&nbsp;The sheets have one common column, "column 10" for simplicity, but "sheet A" has 5000 rows of data, and "sheet B" has 65.&nbsp;&nbsp;&nbsp;How can I isolate the rows in "sheet A" that have the identical data in "column 10" as "sheet B" ?&nbsp; &nbsp;

rachel · Answer

myles11976&nbsp;I think you can use below formula to sort this:https://exceljet.net/formulas/extract-common-values-from-two-lists&nbsp;

Forum Discussion

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

Resources