Remove Duplicates Based On Sort Order

This video show how to removed duplicates in one column based on the sort order of another column. There are two example shown. The first example works well with a small data set. For larger data sets (over half million records for example), the Power Query feature works better and I show an example in the later part of the video. I picked up the Power Query solution from a Microsoft forum discussion at https://social.technet.microsoft.com/Forums/en-US/00a09332-fe6e-47a4-a8a9-b71e38b01a86/how-to-remove-duplicates-based-on-sort-order?forum=powerquery 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel #excel #msexcel #doughexcel