How to Find Triplicates in Excel
By default, Excel highlights duplicates( north) and triplicates (2). Follow the below steps to highlight only triplicates:
Step 1: Firstly clear all your previously applied rules.
Step 2: Now select the range of cells.
Step 3: Select the Conditional Formatting in the Styles group in the Home tab.
Step 4: Click the new rule
Step 5: Select ‘Use a formula to determine which cells to format’.
Step 6: Enter a formula
COUNTIF($A$2:$A$9,A2)=3
Step 7: Select a formatting style and click OK.
Result: Excel highlights the Triplicates (integer and string).
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.