Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel LOOKUP Function
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to get first column number in range in Excel
  • How to use Excel ROW Function
  • Get nth match with INDEX / MATCH in Excel

Data Analysis Examples

  • Create Scatter Chart in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Conditional Formatting Rules in Excel
  • Get column index in Excel Table
  • Number and Text Filters Examples in Excel

Data Validation Examples

  • Excel Data validation specific characters only
  • Excel Data validation no punctuation
  • Excel Data validation must begin with
  • Excel Data validation allow uppercase only
  • How To Create Drop-down List in Excel

Remove Duplicates Example in Excel

by

When duplicates are removed in Excel, the first occurrence of the value in the list is kept, but other identical values are deleted.

This example teaches you how to remove duplicates in Excel. Go here to only find duplicates.

Worked Example:   How To Remove Duplicates In Excel Column Or Row?

1. Click any single cell inside the data set.

2. On the Data tab, in the Data Tools group, click Remove Duplicates.

The following dialog box appears.

3. Leave all check boxes checked and click OK.

Worked Example:   Filter Data Based on Date in Excel

Result. Excel removes all identical rows (blue) except for the first identical row found (yellow).

To remove rows with the same values in certain columns, execute the following steps.

4. For example, remove rows with the same Last Name and Country.

Worked Example:   Add Outline to Data in Excel

5. Check Last Name and Country and click OK.

Result. Excel removes all rows with the same Last Name and Country (blue) except for the first instances found (yellow).

Post navigation

Previous Post:

How to create a Histogram in Excel

Next Post:

Flash Fill in Excel

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Two ways to Compare Text in Excel
  • How to count total characters in a range in Excel
  • How to extract domain from email address in Excel
  • Get first name from full name — Manipulating NAMES in Excel
  • Display Days in month in Excel
  • Add decimal hours to time in Excel
  • Convert Unix time stamp to Excel date
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Count holidays between two dates in Excel
  • Calculate periods for annuity in Excel
  • How to calculate annual compound interest schedule in Excel
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles