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.