If you have ever needed to remove duplicates from a database in Excel, you will know how incredibly useful this tip is.
This is so simple and quick to use. Remove Duplicates does exactly what you’d expect — it removes the duplicates in any given range of data.
Excel’s Remove Duplicates tool is found:
– on the Data Ribbon…
– in the Data Tools section of the Ribbon.
BONUS: If you just want to highlight duplicates, you can do this using Conditional Formatting. The shortcut to get you there is Alt H L. (Or find it on the Home ribbon under Styles).
Thanks to Harvard Business Review for this tip.
If you have a Tech Tip suggestion, please let me know.
For great time-saving tips,
look up our tips on Being more efficient with your technology or look through the the Technology Information for Staff website.
Was this tip helpful to you? Anything else you want to know? Please leave a comment below.
You’ll find more learning at Learning and Development.