跳转到内容
Text To Table Converter

Find Duplicate Cells

The Find Duplicate Cells tool allows you to locate cells that contain duplicate values within your selected range, current sheet, or across all sheets in Google Sheets™.

How to Use Find Duplicate Cells

Section titled “How to Use Find Duplicate Cells”

  1. Open the Find Duplicate Cells feature Navigate through the Google Workspace™ menu: Extensions > Text To Table Converter > Mega Tools > Find Duplicate Cells.

  2. Choose your range scope Select where to search via radio buttons:

    • Selection (default) - Search only within your currently selected range
    • Current Sheet - Search the entire active sheet
    • All Sheets - Search across all sheets in your spreadsheet

  3. Configure options (optional) Click the caret button to expand the options panel:

    • Trimming: Toggle to trim leading/trailing whitespace (default: on)
    • Case sensitivity: Toggle for case-sensitive comparison (default: case-insensitive)

  4. Find duplicates Click the main “Find duplicates” button to search for duplicate cells.

  5. Review results The results table appears with:

    • Checkbox column for selection
    • Location column showing cell reference (e.g., sheet!A1)
    • Type badge showing “Duplicate”
    • Tooltip showing display value on hover
    • Collapsible table with count in header

  6. Select duplicate cells Use checkboxes to select specific duplicate cells you want to manage.

  7. Apply actions to selected cells Action buttons enable when selection exists:

    Highlight - Apply colors to selected duplicates:

    • Single color: All selected cells highlighted with one color (default: MT yellow #FFEB3B)
    • Multi-color by group: Different duplicate groups highlighted with different colors, interpolated between min and max colors (default: red #f44336 → green #4caf50 gradient)

    Delete - Remove duplicate cells with options:

    • Keep occurrence: First (default), Last, or None
    • Create backup sheet: Checkbox (default: off) - Creates a backup before deletion

    Copy result - Copy the range and display value to clipboard (same as Find Values feature)

Comparison Basis

Section titled “Comparison Basis”

The tool compares cells based on:

  • Display value of the cell (not the formula)
  • Ignores blanks by default
  • Trimming: Leading/trailing whitespace is trimmed (default: on, toggleable)
  • Case sensitivity: Case-insensitive by default, with toggle for case-sensitive comparison
  • Formulas: Compared by their displayed result (implicit; no toggle needed)

Use Cases

Section titled “Use Cases”
  • Data validation - Find duplicate entries that shouldn’t exist
  • Error detection - Identify cells with identical values that may indicate data entry errors
  • Data cleaning - Locate and remove duplicate cell values
  • Quality assurance - Verify data uniqueness in specific columns
  • Pattern analysis - Understand how often values repeat in your data