PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO REMOVE DUPLICATES IN EXCEL?

INTRODUCTION

Many times in our reports we are stuck will lengthy columns containing hundreds or thousands of rows. Sometimes these columns contain repeated rows, which are extremely hard to find manually, because if we do so, it is going to be very hectic and time consuming.

But thanks to Excel which provides us many options to remove such repeated data easily.

In this article we will discuss one such method to remove the duplicated rows from the given columns.

EXCEL provides us a direct solution for the problem known as REMOVE DUPLICATES.

This option facilitates to instantly remove the duplicate values from any column. The option removes all the duplicated rows and create a new column with unique values only.

There are several options which EXCEL asks before we execute the option. Let us find out the way to use REMOVE DUPLICATE option in Excel.

BUTTON LOCATION TO REMOVE DUPLICATES IN EXCEL

The button for REMOVING DUPLICATES can be found under the DATA TAB >DATA TOOLS as shown in the picture below.

KEYBOARD SHORTCUT TO REMOVE DUPLICATES IN EXCEL

The keyboard shortcut for REMOVING DUPLICATES is

ALT+A+M

STEPS TO USE KEYBOARD SHORTCUT

  • SELECT THE RANGE IN WHICH WE NEED TO FIND OUT DUPLICATES.
  • PRESS ALT AND KEEP IT PRESSED.
  • IN A SEQUENCE PRESS A AND AFTER THAT M.

STEPS TO REMOVE DUPLICATES IN EXCEL

STEPS:

  • Select the column or a range, from which you want to remove the duplicate values.
  • Click the button, remove duplicate or click ALT+A+M.
  • A dialog box as shown in picture will open.
  • Select the columns for the checking of duplicate values and click OK.
OUTPUT

The duplicate values from each column has been removed as desired. The data is left without any repeated value.

OTHER WAYS TO REACH THIS ARTICLE

  • FIND OUT DUPLICATES IN EXCEL, REMOVE DUPLICATES, HOW TO REMOVE DUPLICATES, WAYS TO REMOVE DUPLICATES

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: