1. Detect Missing Products
Check which products from your old list are missing in the new one.
=IF(ISNA(MATCH(A2, 'NewList'!A:A, 0)), "Missing", "Exists")
2. Identify Duplicate Products
Use formulas to quickly find duplicate SKUs in your sheet.
=IF(COUNTIF(A:A, A2)>1, "Duplicate", "Unique")
3. Conditional Formatting
Highlight missing or duplicate products without extra columns.
Select your SKU column
Format → Conditional Formatting → Custom formula:
=ISNA(MATCH(A2, 'NewList'!A:A, 0)) → Highlight missing
=COUNTIF(A:A, A2)>1 → Highlight duplicates
Choose a color fill
4. Automated Tools (Apps Script or Add-ons)
function highlightIssues() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Products");
// loop through SKUs and mark missing or duplicates
}
Automate detection instantly with Symdeslow Compare Tool.