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!