This add-in will help you find duplicate records in your online Excel sheet in seconds. It streamlines the process with the main options you need:
It quickly scans the selected range and shows you the number of found entries.
Follow three simple steps to remove duplicates from your sheet: select your table and key columns, decide if you want to find duplicate or unique entries, and choose what to do with the results. Once you click Finish, the add-in will process your data in seconds.
Please note that this add-in does not support Excel 2013.
Duplicate Remover is perfect if you want to instantly de-dupe your table in Excel online or Excel 2016.