MENU
Donate
=DIRECTORY.ENTRY
support.microsoft.com

Filter Unique Values or Remove Duplicates

Microsoft guide to filtering unique values and removing duplicate records in Excel.

  • Sites
  • Free
Visit support.microsoft.com (opens in a new tab)

What it is

Two related but distinct operations are covered on this official page: temporarily surfacing only distinct values through the Advanced Filter, and permanently deleting exact-duplicate rows using the Remove Duplicates tool. Understanding the difference helps you choose the right approach when cleaning imported datasets or auditing lists before analysis.

At a glance

Source
support.microsoft.com
Type
Microsoft Excel sites
Category
Official Microsoft
Cost
Free

Also in Official Microsoft

All microsoft excel sites