How to Check Duplicates in Google Sheets

{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Check Duplicates in Google Sheets", "description": "Learn how to check for duplicates in Google Sheets using conditional formatting or formulas. Quickly find and highlight repeated values.", "step": [ { "@type": "HowToStep", "name": "Open your Google Sheet and select the column to check", "text": "In Google Sheets, highlight the column or cell range where you want to check for duplicates, such as A2:A100." }, { "@type": "HowToStep", "name": "Go to the Format menu and choose Conditional formatting", "text": "Click Format in the top menu, then select Conditional formatting to open the sidebar on the right." }, { "@type": "HowToStep", "name": "Apply a custom formula rule to find duplicates", "text": "In the sidebar, under Format cells if, choose Custom formula is and enter =COUNTIF(A:A, A2) > 1 if checking column A." }, { "@type": "HowToStep", "name": "Set a highlight style and click Done", "text": "Choose a formatting style like a background color to highlight duplicates. Click Done to apply it and instantly flag repeated values." }, { "@type": "HowToStep", "name": "Use UNIQUE or COUNTIF formulas to isolate duplicates", "text": "To list only duplicates, use =UNIQUE(FILTER(A2:A, COUNTIF(A2:A, A2:A) > 1)) in an empty column." } ] }