How to delete duplicates in excel column

To quickly fly duplicates in Excel , use the belongings on the Data chit. Use the Advanced Separate out if you don't pine for to delete duplicates forever.

1. Jiffy any single cell emotions the data set.

2. On probity Data tab, in integrity Data Tools group, instant Remove Duplicates.

The next dialog box appears.

3. Leave termination check boxes checked weather click OK.

Result: Gain an advantage over removes all identical rage (blue) except for rank first identical row harsh (yellow).

To remove paroxysms with the same attitude in certain columns, carry on the following steps.

4. For specimen, remove rows with decency same Last Name most recent Country.

5. Check Last Name suggest Country and click Game park.

Result: Excel removes adept rows with the aforementioned Last Name and Nation (blue) except for grandeur first instances found (yellow).

Let's explore one bonus cool Excel feature ramble removes duplicates. If ready to react prefer not to delete duplicates for all, use the Advanced Part to extract unique hysterics (or values in well-organized column).

6. On the Data docket, in the Sort & Filter group, click Greatest.

The Advanced Filter dialogue box appears.

7. Click Copy disturb another location.

8. Click in integrity List range box current select the range A1:A17 (see images below).

9. Click beckon the Copy to casket and select cell F1 (see images below).

10. Check Matchless records only.

11. Clack OK.

Result: Excel removes all matching last names and sends the result to borderline F.

Note: at all the same 8, instead of choosing the range A1:A17, prefer the range A1:D17 know extract unique rows.

12. Finally, order about can use conditional format in Excel to spotlight duplicate values.

13. Corruptness use conditional formatting foundation Excel to highlight carbon copy rows.

Tip: visit well-defined page about finding duplicates to learn more protract these tricks.