Excel Remove Duplicates Part 2: Keep Most Recent Data

In this video, I demonstrate how to remove duplicate records in Excel while keeping the most recent entries based on the invoice date. I'll walk you through an example where we sort data by customer number and invoice date, and then use the 'Remove Duplicates' feature effectively. This technique ensures that only the most recent purchase records are retained, making data management easier. Stay tuned for more Excel tips and tricks. 00:00 Introduction and Problem Statement 00:14 Example Scenario: Identifying Duplicates 01:07 Sorting Data by Customer Number and Invoice Date 01:48 Removing Duplicates While Keeping the Most Recent 02:21 Verifying the Results 02:54 Conclusion and Further Learning And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!