Show duplicates in Excel
If you want to display and remove redundant duplicates in Excel, you can easily do this with a little trick. Instructions for this can be found in this article.
How to find duplicates in Excel
- First, mark all numbers in Microsoft Excel that are to be examined for duplicates.
- For example, if you want to filter out the duplicates of the entire data series, click on the box between "A" and "1" (diagonally next to cell A1).
- Then select the "Conditional formatting" button in the "Start" menu under "Format templates" (see image).
- Now click on "Rules for cell highlighting" and then on "Duplicate values".
- All duplicate cells are now displayed in red.
Become an Excel professional with the new course at the CHIP Academy
With the course in the CHIP Academy "Excel: Pivot tables in less than an hour" even beginners learn how to handle a large amount of data quickly and easily.
- Learn in 40 minutes from our lecturer Daniel Kogan what pivot tables are and how to use them sensibly.
- You will learn how to use pivot tables and pivot charts to gain insights and insights from your data that you would otherwise not have been able to access.
- Visit the CHIP Academy and get the extensive online video workshop for 19.90 euros.
Read here how you can remove all duplicates from the Excel folder with one click.