When you have duplicates values within your Excel Table there is a quick and easy way to remove those values.

The duplicate values could be all over your Excel Table and sometimes it takes valuable time trying to locate those duplicates and then deleting them.

Not to worry, Remove Duplicates to the rescue!

STEP 1: Click inside your Excel Table and select Table Tools > Design > Remove Duplicates

STEP 2: This will bring up the Remove Duplicates dialogue box.  Select only the Column box that contains the duplicates that you want to remove and press OK

DOWNLOAD WORKBOOK

Remove Duplicates3

HELPFUL RESOURCE:

Excel Tables

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Dynamic Data Validation List What´s a dynamic data validation drop down list in Excel, you say?Well, as you add new data into your Excel Table, your drop down list automatically gets updated.That is a cool feature and it means that you do not need to update your data validation source reference each ...
Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error.This means that the formula refers to a cell that isn’t valid.To get rid of this error message we have to select the cell(s) with this error, ...
What Microsoft Excel Version Do I Have? We know that Microsoft Excel has different features across different versions and there are several Excel version, like Excel 2003, 2007, 2010, 2013 and 2016!So whenever I use Microsoft Excel I want to know right away which Excel Version I am using.  And boy, do I get confuse...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list.A dynamic drop down list expands as the Excel Table expands when new data gets added to it.This is great when you want to have users select from a predefined ...