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
SUBTRACTION AND ADDITION IN DATE FUNCTION
EXCEL TRICKS
Calculations with Date in Excel

Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are working on large database, this become tedious job for calculating date difference Here we discussed the various scenarios where we …

Date Function in Excel
EXCEL TRICKS
Date Function in Excel

While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that helps in various calculations. This Function also helps to convert the serial numbers to Date format of your …

Logo Inserting Symbols in Excel
EXCEL TRICKS
How to Insert Symbol in Excel Numbers?

Have you ever faced the challenge while using special character symbols in number formatting or any customized number formatting? It is an easy method to insert any symbol in numbers i.e Delta Symbol or Special Character Symbols in Excel Number Formatting.  You may easily do this by following below steps: …

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn