How to find duplicate values in Excel?
You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF
Duplicates
Remove Duplicate values in Excel
Discover how to remove duplicate values in Excel from one column or many columns from the ribbon or by formula
Anonymise your data
Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed
Keep your Last Updated Data
Keep the last updated row Let's start from a file storing customer information. Some customers have multiple records in the file, as a new record was created each time they changed their address or phone number. How do you keep only the last updated row? 🤔🤨 Remove duplicates not applicable With a such file, you […]
