How to Find Duplicate Rows in Excel
Use COUNTIFS (with a S at the end) instead of COUNTIF to locate and highlight duplicate rows in Excel.
Step 1: Select the range A1:C16
Dataset
Step 2: Go to the Home tab and Select Conditional formatting
Click Conditional Formatting under the Styles group on the Home menu.
Step 3: Click on New Rule
Excel New Rule
Step 4: Select ‘Use a formula to determine which cells to format’
Step 5: Enter the formula
=COUNTIFS(Business,$A1,Gender,$B1,Ethnicity,$C1)>1
Step 6: Select a formatting style and click OK
New Formatting Rule
Result: Excel highlights the duplicate rows.
Highlighted Duplicates
How to Find Duplicates in Excel
Duplicates are those which appear more than one time. Finding and highlighting duplicates in Excel is a common task that helps in data analysis and management. While working with a large Excel worksheet or converting many small worksheets into bigger ones, you may find many duplicates in it.
In this article, we will look at different ways we can find duplicates in Excel easily and quickly.
Contact Us