Excel remove Duplicates

With Excel 2016, Duplicates can be removed quite easily. Just select any row in the table . Then activate the data tab in the ribbon menu and click on the Remove Duplicates option in the Menu. And then select the columns where Duplicates should be removed. Once you do that, it would give you a notification as to the number of Duplicates removed and the number of remaining rows in the table.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s