Leila Gharani is the founder of XelPlus and a famous Microsoft Excel instructor and YouTuber. She has more than 1.6 million subscribers on her YouTube channel. Her goal is to help people save time so they can spend it on activities that matter. Her videos deal with a bunch of work related platforms such as: Microsoft Excel, PowerPoint, VBA, OneNote, Google sheets, and also Accounting and finance tips.
These are 3 easy ways to remove duplicates in your data to create a unique / distinct list of values in Microsoft Excel. It’s a very common task for data cleaning and also a very common job interview question. One of the solutions (removing duplicates with power query) returns a different result to the other methods. Leila explains what the difference is and what to watch out for when using these methods.