Microsoft Support Microsoft Support is here to help you with Microsoft products Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows 11, Surface, and more
Filter for or remove duplicate values | Microsoft Support You can filter for unique values to temporarily hide duplicate values, and you can remove duplicate values to permanently delete duplicate values A duplicate value is one where all values in the row are an exact match of all values in another row
Filter for unique values or remove duplicate values Windows Web In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, select Data > Sort Filter > Advanced To remove duplicate values, select Data > Data Tools > Remove Duplicates To highlight unique or duplicate values, from the Home tab, use the Conditional Formatting command in the Style group Learn about filtering for
Finden und Entfernen von Duplikaten | Microsoft Support So finden und entfernen Sie Duplikate in Excel Filtern Sie nach eindeutigen Werten in großen oder kleinen Datasets, um Ihre Arbeitsblätter und Arbeitsmappen zu sauber
Overview of PivotTables and PivotCharts | Microsoft Support Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements and terms
Count unique values among duplicates | Microsoft Support Count unique values among duplicates Let's say you want to find out how many unique values exist in a range that contains duplicate values For example, if a column contains: The values 5, 6, 7, and 6, the result is three unique values — 5 , 6 and 7
Rechercher et supprimer des doublons | Microsoft Support Comment rechercher et supprimer des doublons dans Excel Filtrez les valeurs uniques dans les jeux de données volumineux ou petits pour propre vos feuilles de calcul et classeurs