Have you ever dealt with duplicate records in your data? What a pain in the butt that is, especially if there are a lot of duplicates.
Have you tried sorting and deleting them individually? That makes it easy to make a mistake, we are human after all.
Maybe you tried to create a Pivot Table and used the count function to find multiple items.
Thankfully, Excel has a super easy way to remove duplicates – but there is a trick to it…
Watch the video to learn the easy trick to removing actual duplicate items from your data.