Use Power Query to Separate Unique and Duplicate Values in List
Have you ever want to get unique and duplicate values from a table all in one sheet? Well...you've come to the right place. I'll show you two ways to do this. The first example is going to use conditional formatting and filtering to get a list of unique and duplicate values to put on separate columns. The second example is going to cover how to do the same thing with Power Query. The main advantage of using Power Query is that if you are doing this task on a recurring basis (i.e., weekly or daily), Power Query make it so much easier to do. The initial setup may take longer, but if we were to repeat this task it is actually faster. Check out the video to see how this is done.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 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.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~