Excel – LibreOffice – Find duplicates in a row

If you have a list of records that have many duplicates and you want to highlight them so that you can remove or update it quickly.

E.g. For this case

You can use this formula to find duplicated rows easily in Excel and LibreOffice


The result will be like this


Hope it is helpful for you 🙂



No comments yet.

Leave a Reply