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

=IF(COUNTIF($A$1:$A$15,A1)=1,"","Duplicated")

The result will be like this

Hope it is helpful for you 🙂