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