Remove Duplicates in Excel & List Unique Values
When it comes to HR and compensation data, it’s so important to get this information right.
Having duplicates in your excel data set can lead to errors, and we all know the headaches associated with making decisions on wrong information!
In this video, I’m going through an easy step-by-step process of reviewing your data, identifying the duplicates, and removing these duplicates.
You’re left with a sparkly clean Excel sheet with distinct values that are easy to understand and sort.
For the video, we’re using one of the Time-Saving Templates from our HR template collection: the Employee Total Rewards Statement. This tool is a great way of streamlining your process and providing a nice snapshot of all the perks and benefits provided to your employees, with a total rewards statement.
You can find the Employee Total Rewards Statement here:
https://timesavingtemplates.com/produ...
Grab a free compensation metric cheat sheet here: https://timesavingtemplates.com/freer...
We’ll be coming back with more exciting templates and excel hacks, so stay tuned!