Tag Archive: Duplicates

Articles sur le thème : Duplicates

Remove Duplicates

Presentation of the tool Remove Duplicates It is very easy in Excel to extract all unique values from a list of data using the tool Remove Duplicates. This tool exists in any version of Excel. Since the Excel 2007 version, the menu is directly accessible from the ribbon. But for versions prior to Excel 2003, the …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/remove-duplicates/

Keep the last update of your data

Too many data for the same contact Let’s start from this file where we have different informations about our clients. Sometimes, we have many different data for the same customer. We want to keep only the newest information for each customer based on the column Update. Remove Duplicates not applicable With a such file, you …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/keep-last-update-data/