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

Your duplicates are now removed!



DOWNLOAD WORKBOOK

 

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