You are viewing an old revision of this post, from January 2, 2018 @ 17:59:36. See below for differences between this version and the current revision.

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

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

The result will be like this

 

Hope it is helpful for you 🙂

 

Revisions

  • January 2, 2018 @ 17:59:36 [Current Revision] by Sharing Solution
  • January 2, 2018 @ 17:59:36 by Sharing Solution

Revision Differences

There are no differences between the January 2, 2018 @ 17:59:36 revision and the current revision. (Maybe only post meta information was changed.)

No comments yet.

Leave a Reply