How to remove duplicate data from the table in excel?

image_pdf

The duplicate data in a spread sheet is the one where all the values in a given row match with the all the values in another row.To remove the duplicate data either you can first filter the table and then apply the “remove duplicate” option or directly apply the option.

Example:

The following example shows how to remove duplicate data.

1. Sort the data.

dup

2. Go to Data-> Remove Duplicates.

dup1

3. Select Column in which you want to remove duplicates.

dup2

4. Result: See the duplicate entries are removed from the data.

dup4

1,482 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>