Remove Duplicates But Keep First Instance in Excel | 4 Methods

In this Microsoft Excel video tutorial, I demonstrate how to remove duplicates but keep the first instance of the value or record. There's quite a few ways you can do this in Excel, this video covers four methods:

00:00 Introduction
00:28 Method 1: Remove Duplicates button (simplest method)
02:13 Method 2: The UNIQUE Function (best dynamic method)
03:53 Method 3: Advanced filter
04:32 Method 4: Power Query (case sensitive)

#exceltutorial #exceltips

[Hootiemomma]

Thank you!!! You solved my problem. 😊

[stephmcc]

Thank you so much I had 5000 duplicates and this saved my sanity!