Google Sheets Tip: Compare Two Columns and Extract Missing Values
You may run into a situation where you need to compare two spreadsheets and figure out which values exist in one but not the other.
For example, if you run an ecommerce store where your supplier provides you a spreadsheet of their inventory that's constantly changing, you may need to figure out which new products exist in the data feed that you currently don't have published in your store.
One way to figure this out is to export the current product data …
Read more