Remove Duplicates in Single Column


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”

Leave a Reply

avatar
Find Duplicate
EXCEL TRICKS
Find Duplicates in Excel

Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and Remove duplicates. So you may watch my detailed video on “Complete Guide for Handling Duplicates” Here I will be explaining one …

EXCEL TRICKS
Few Simple Excel Tips – Excel Learner Should Know

1. Change Direction When You Press Enter Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very simple. Do you want to change the direction? So let’s do it Click on below highlighted button “File”: …

EXCEL TRICKS
Impress your Clients by Hiding these Simple Features

While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to your bosses, clients because after hiding these features, you excel sheet looks like a software …