Check duplicates before deleting rows COUNTIF flags repeated IDs, but flagged rows are not always rows to remove. Try this synthetic example Enter R001, R002, R002, R003, R003 in A2:A6, one per row. In B2, enter =COUNTIF($A$2:$A$6,A2) and fill down....