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.
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.
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.