excel for mac 2011 how to remove duplicates

For a large data set with hundreds or even thousands of names, the ability to remove duplicate entries in a semi-automated way could potentially save you days of hunting.

Today were going to create a small set of data, and remove duplicate entries through Excels own duplicate removal tools.

Open an Excel workbook, or create a new one if you want to follow along.

If theres no existing data, youll have to add some dummy text to try this out yourself.

For the sake of this tutorial, I just made a list of artists and bands, duplicating a few names along the way.

Select a column (or columns) to look for duplicated data.

If youre using a large data set, Id recommend selecting each column individually.

Often times, theres a name in a different column thatll match the first column, but wont be a duplicate we need to remove.

Open the Data tab at the top of the ribbon.

Find the Data Tools menu, and click Remove Duplicates.

Press the OK button on the pop-up to remove duplicate items from your data set.

You can unsubscribe at any time and well never share your details without your permission.

Excel For Mac 2011 How To Remove Duplicates