Tag Archive: Duplicates

Articles sur le thème : Duplicates

Remove Duplicates

The tool Remove Duplicates Since Excel 2007 In these versions, the tool Remove duplicates is in the tab Data.     To extraction without duplicates, you have to follow this 2 steps Select the column where want to remove the duplicates Click on the tool Remove Duplicates In the next dialog box, indicate if the …

Continue reading

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

Keep your last updated data

Keep the last updated row Let’s start from a file where we store customers informations. Some customers are many times in your file when they change their phone number or address How do you keep only the last updated row? Remove Duplicates not applicable With a such file, you can’t use the tool Remove Duplicate. …

Continue reading

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

Anonymise your data

If you work on a workbook with confidential data, you need to anonymise your data if you collaborate with other people. The technique is not really complex but you have to respect the following steps. The initial document Imagine you are a journalist and you receive the following file in your mailbox (it’s all fake data). …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/anonymise-your-data/