How to find duplicate cells in an Excel sheet

[sumaiyakhatun24]

Ercole Palmeri 2023-11-15
Excel Tutorial
A great function for finding errors or cleaning up an Excel file is to find duplicate cells.
There are many methods to find duplicate cells, in this article we will look at two simple methods to find and highlight duplicate cells in an Excel spreadsheet.
Find duplicate cells in Excel
To illustrate how to find duplicate cells in Excel, let's use the simple spreadsheet below, which contains a list of names in column A.

Table with duplicate cells
Let's first show how to use conditional formatting to highlight duplicate cells, and then lebanon rcs data show how to use the function Countif Excel to find duplicates.

Highlight duplicate cells using conditional formatting
To find duplicate cells with conditional formatting, follow these steps:

Select the range of cells to format.
Select the Conditional Formatting drop-down menu from the Home tab at the top of your Excel workbook . Within this menu:
Select the option Highlight cell rules and, from the secondary menu that appears, select the Values ​​option Duplicates … ;
Excel highlight duplicate cells rules
The " Duplicate Values " drop-down menu on the left side of this window should show the "Duplicate" value (although this can be changed to only show unique values ​​instead of duplicates).