How to find duplicates in a Microsoft Excel list
Filed in Excel on Sep.15, 2006. Email This article to a Friend
Finding duplicates in a large excel list is a tremendous hard work. Microsoft Excel is a perfect tool to solve this problem.In a new column, preferably next to the start value of your list, create a new formula: =IF(COUNTIF($A$1:$A$10,A1)>1,"Double","")
Copy that formula to all adjacent cells of your list.
Make sure that "$A$1:$A$10" in COUNTIF($A$1:$A$10,A1) covers the list range you want to check for duplicates.
Related blog posts
- Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel part 2
- Create a list of duplicates where adjacent cell value meets a condition in excel
- Extract duplicates and their adjacent values
- Extract a list of duplicates from a column using array formula in excel
- Extract a list of alphabetically sorted duplicates from a column in excel
Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.Don´t forget to add my