Remove Duplicates in Single Column

42.5 Remove Duplicates

When you see duplicate data in single column, you may follow this article to remove these duplicates with few clicks.

If you see below screenshot, I have duplicates available in my Column A which are highlighted in yellow:

42.1 Remove Duplicates
  • Highlight/Select the Column A, similar to shown in below screenshot:
42.2 Remove Duplicates
  • Go To “Data” tab on Menu Bar and click on “Remove Duplicates” as shown below:
42.3 Remove Duplicates
  • Once you click on “Remove Duplicates”, it may show you below window. You need to select “Continue with the current selection

    Note: If you do not see this window, please go to next step
42.4 Remove Duplicates
  • Then you will see below window, so you need to select the Column which may contain the duplicate data and click Ok.
42.5 Remove Duplicates
  • Once you click Ok, it will remove the duplicates value. You may refer to my video to learn this trick and refer to next section to learn “How to delete duplicates in Multiple Columns”
Author: was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply