Choose specific columns. Rows with same values in those columns = duplicate.
🔲
Full Row Match
All columns must be identical for a row to count as duplicate.
🔀
Cross-Column Match
Same value appearing in ANY column across different rows gets flagged.
Select Columns to Check
Select one or more columns. Rows are duplicates if all selected columns match.
⚡ Cross-Column mode checks every value across ALL columns. If a value like 01711234567 appears in Row 3 Column A and also in Row 7 Column B — it gets flagged.
Optionally restrict to specific columns
Leave all unselected to scan every column. Or pick only the columns you want to compare across.
Detection Options
Case Sensitive
"ABC" ≠ "abc"
Trim Whitespace
Ignore leading/trailing spaces
Ignore Blank Cells
Empty values not flagged
Normalize Numbers
"1,000" = "1000"
Partial Match
Flag if one value contains another
Keep First Occurrence
First row = original, rest = duplicates
