Tag Archive: Duplicates

Articles sur le thème : Duplicates

Remove Duplicates

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 tool is …

Continue reading »

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

Extract without duplicates with formula

It is very easy to extract without duplicates data from a table through the menu Data>Remove duplicates. It works great for one or more columns but the thing about this tool is that you can not control data that will be delete. I recently worked on a customer address file by keeping only the most …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/extract-without-duplicates-with-formula/

Keep your last data update

Too many data entries for the same contact Let's start from a file where we store client information. Sometimes, we have many different data entries 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 can't …

Continue reading »

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