Three EASY Ways to Find and Remove Duplicates in Excel

Рет қаралды 1,208,259

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover three efficient methods to remove duplicates from your Excel data in this detailed tutorial. Whether you're preparing for a data or financial analyst job interview or just looking to enhance your Excel skills, this video is packed with valuable insights. We explore a common data cleaning task and explain the advantages and disadvantages of each method, including a case-sensitive approach unique to Power Query.
⬇️ Download the workbook here: pages.xelplus.com/remove-dupl...
🔍 What You'll Learn:
▪️ Remove Duplicates Feature: A straightforward method available in all Excel versions. Learn how to use it for your entire dataset or just specific columns.
▪️ UNIQUE Function (Office 365 Exclusive): Harness the power of Excel's dynamic functions to automatically update your data as you add new entries.
▪️ Power Query Method: Discover a semi-dynamic approach that is case-sensitive, offering a unique advantage in certain data scenarios.
00:00 How to Remove Duplicate Values For Multiple Columns
01:15 How to Use the Remove Duplicates Feature
03:09 How to Use the UNIQUE Function
04:50 How to Use Power Query to Remove Duplicates
08:25 Wrap Up
► LINK to more Power Query tutorials: • Excel Power Query (Get...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Пікірлер: 536

@LeilaGharani 9 ай бұрын

Grab the file I used in the video from here 👉 pages.xelplus.com/remove-duplicates-methods-file

@mayanksrivastava6085 2 жыл бұрын

I Like you voice and speaking skills

@thenotidevil 2 жыл бұрын

Hope you focus on content too

@mayanksrivastava6085 2 жыл бұрын

@@thenotidevil..... Like you are focusing on other people comments 😀

@Anastasia-wy1uj 2 жыл бұрын

Pls make a video on finding, keeping and distinguishing between duplicates. 😊

@colormile-vid8888 2 жыл бұрын

I use remove duplicates a lot but I think I like the unique fx better. Power query is great for big data sets. Another great tutorial for daily use in excel. TFS! Have a great day!

@rohitjha6248 2 жыл бұрын

Another informative video. Nice to know the fundamental difference while applying the unique and power query for removing duplicate records.

@smileycindy 2 жыл бұрын

Fabulous demonstration! Loved seeing the results side by side with the differences. Thanks!

@LeilaGharani 2 жыл бұрын

You are so welcome!

@knowledgehub4192 2 жыл бұрын

Very well explained, perfect way of making others understand.

@kroyhevia 2 жыл бұрын

Exactly what I needed Thank you!

@ekevanderzee9538 2 жыл бұрын

I used to be an Excel expert. After having discovered your channel I am convinved I must take a course of some sort. Never realised it developed so much.

@josenildoalmeida8799 2 жыл бұрын

Muito bom, Leila. Excelente conteúdo! Obrigado por compartilhar!!

@TPzita 2 жыл бұрын

I use all this tools all the time, and I still learned something new … impressive :)

@samvan7787 2 жыл бұрын

Always enjoy your video - short, concise, to the point with real example, and don't waste anytime.👍

@mijoizagas3747 Жыл бұрын

Useful information, thank you!

@ahsanlive Жыл бұрын

My gratitude to you for all you have taught, which I will never forget. I truly appreciate you and your time you spent helping us in many occasions. Thank you very much for the course. I enjoyed every minute of your lecture and practical lesson as well as your marvellous sense of humours. I really appreciate you to teaching is such so easy way, Thank you so much, so nice of you..

@soundofmusic0613 2 жыл бұрын

I've always relied on your videos everytime I want to learn something new in Excel. Thanks!

@shironmania 2 жыл бұрын

Not only the formulas are dynamic, even you are. Very useful vid indeed

@user-tf7te5fs2n 2 жыл бұрын

We want more video like this, the video that can help us in tests and interviews Thank you for the video💕

@Maya-sv1pz 2 жыл бұрын

great info as always. I've been doing it the more rudimentary and manual way using countif function. These built in methods are certainly more practical especially when it comes to transitioning the data cleansing work!

@johkwalter9225 2 жыл бұрын

Very helpful. Thank you Leila

@user-tm1eq8rz5s 2 жыл бұрын

Good one. Thanks!

@bonguthandokhumalo7552 2 жыл бұрын

Thank you so much, great lesson!

@TheBipin819 2 жыл бұрын

Excellent and easy. Thanks 🙏

@juanvalenzuelal1839 2 жыл бұрын

The best ! Thank you Leila

@muscleman0009 2 жыл бұрын

Thanks for posting this...very needed!

@anv.4614 2 жыл бұрын

Thank you. Well explained

@HadesTimer 2 жыл бұрын

This is great, it's going to speed up my workflow so much. Thank you.

@lohitr9216 Жыл бұрын

Thank you. Easily understood 👌

@asimali5820 2 жыл бұрын

Thank you for sharing ideas and techniques

@nadermounir8228 2 жыл бұрын

Thank you Leila. Great explanation 👌

@TheRapidram 2 жыл бұрын

Very useful video, thanks for sharing.

@keshoweatherz8499 2 жыл бұрын

Very helpful, thank you

@PhenomenalChezline 2 жыл бұрын

Well that was rather helpful. I wasn’t aware of the power query method but it’s very useful to know that it’s case sensitive. Thanks 👍🏾

@dianal3627 2 жыл бұрын

Thanks. This was great. You can also use Conditional formatting to identify duplicates then remove them.

@Ammar.mrm-2002 2 жыл бұрын

I just wanna say a huge Thank You for your video And Tbh you're one of the most professional people I've ever seen niche :)

@veramoralez7870 Жыл бұрын

Thank you.. you explained it very well.👍

@mohamedgenidy1901 2 жыл бұрын

thank you Leila .... you are the best

@louis-philippetaschereau1944 2 жыл бұрын

Very clear and handy. Editing is great. Thank you.

@ramen10lass78 2 жыл бұрын

Thank you so much Leila. This is very helpful too.

@CJ-gn8ud 2 жыл бұрын

Thank you for the useful information!

@leeannhadgis5985 2 жыл бұрын

Thank you! You are an excellent teacher and your content is so useful!

@LeilaGharani 2 жыл бұрын

You're very welcome, Leeann!

@pieterkaruniadeo3494 2 жыл бұрын

Thanks Leila. The best mentor

@m5ycgxboi250 Жыл бұрын

Love this short cuts

@MrLuckyuser 2 жыл бұрын

Your way of explaining is awesome.

@anbbhatt 2 жыл бұрын

Excellent tips...

@ExcelWithChris 2 жыл бұрын

Thanks! Especially showing how Power Query is case sensitive.

@HowToAnalyst 2 жыл бұрын

Awesome techniques to remove duplicates! Pivot tables are another way to remove duplicates because they de-duplicate items in the rows and columns pane.

@egitafashion4077 2 жыл бұрын

Thank you for great tutorial ,,!!!

@victoriasingveena441 6 ай бұрын

Thanks Leila this is useful for a young Data Analyst like me. 😊

@LeilaGharani 6 ай бұрын

Glad it was helpful!

@LEGIONMAGAZINE 2 жыл бұрын

Thank you, really productive video.

@hwangandy 2 жыл бұрын

veryusefull and help me a lot..Many Thanks

@dwyang2307 2 жыл бұрын

You are the best teacher!

@eslamfahmy87 2 жыл бұрын

Clear and simple thank you

@jackbench5427 2 жыл бұрын

Super helpful, thanks a LOT.

@phpvbacoder9000 2 жыл бұрын

Learned to solve things much easier with your Videos 👍 I used adodb and a group by query in vba for this before.

@ronaldpinto3376 2 жыл бұрын

Very informative, thanks for sharing this wonderful and helpful information.

@tifouraamina1761 2 жыл бұрын

😍 thank you Leila you always save my life

@gmbylsma 2 жыл бұрын

You're such an effective teacher! Thank you!

@bperez8656 2 жыл бұрын

You’re very handsome. Do you have an IG?

@marcusjohnson3650 Жыл бұрын

Very helpful!

@mr.hussain8714 Жыл бұрын

thank you.. this helped me a lot

@rolandpaicely2308 2 жыл бұрын

Great info!

@PeterCharalambos Жыл бұрын

It's obvious..... I can't live without you. Even MS wasn't as clear as you

@joydebghosal.7646 2 жыл бұрын

Just awesome! Proud of you ma'am.

@SyedMuzammilMahasanShahi 2 жыл бұрын

Thanks Leila ... This is so helpful.

@samanthasudathbandaranayak9200 2 жыл бұрын

great one, love it

@rashiedasuliman4138 2 жыл бұрын

Very helpful video once again Leila. Thank you

@LeilaGharani 2 жыл бұрын

My pleasure!

@malihashoaib7719 2 жыл бұрын

really help full thanx

@Luciano_mp 2 жыл бұрын

Very good Leila. Thanks!

@johnborg5419 2 жыл бұрын

Thanks Leila. Always Learning. :) :)

@rilwan343 2 жыл бұрын

Thank you Leila it's very nice

@candymuncher8155 2 жыл бұрын

You're my new hero.

@BrentLayton Жыл бұрын

Thank you!

@AK243RDC 2 жыл бұрын

Amazing ❤! Thank you very much!

@yousrimostafa6962 2 жыл бұрын

Thanks very much

@kkhankkhan7234 2 жыл бұрын

Thanks for sharing

@jayholm9504 2 жыл бұрын

Thank you Leila! Another great lesson to start my Thursday morning! Knowing about the case sensitive aspect of each method is so helpful. You are an awesome teacher!

@LeilaGharani 2 жыл бұрын

You're so welcome, Jay!

@TK-rv7wq 2 жыл бұрын

Jay holm,, where are you from?

@okohlawrence2466 2 жыл бұрын

Always on point.

@RajeshBachuRadhika 2 жыл бұрын

Leila! you are simply master of Excel

@seanmcgrath5686 Жыл бұрын

Thanks for the quick and easy tutorial! you just saved me a ton of time!

@workinprogress5936 Жыл бұрын

Thank you for this, this is exactly what I was looking for.

@FaysalEasyExcel 2 жыл бұрын

This is great 3 in 1. genius.

@bluesky0300 2 жыл бұрын

Amazing !!! I never ever noticed this (even i face issues when removing duplicates) I m using excel for last 26 years, but when i see your videos i feel i m beginner yet. :) Thanks for sharing .....

@joefromdc 2 жыл бұрын

Great Point with PQ, Change the 'Format' simple but effective. Thanks for this tip

@ozzy155 2 жыл бұрын

You are a champ leila. Truely

@kudzaiblessingkanyenze3261 9 ай бұрын

Thank you very much

@samanthadaroga4811 10 ай бұрын

This was quite an instrumental video for my work needs. Thank you kindly Leila!

@LeilaGharani 10 ай бұрын

Our pleasure :)

@alonaisrael 2 жыл бұрын

תודה רבה לילה! את אלופה 👏👏👏

@theresaibhalukholouduehi8406 4 ай бұрын

This was very helpful. Thank you

@LeilaGharani 4 ай бұрын

You're welcome!

@chinthaka7245 Жыл бұрын

Thank you..... Great Job....

@gaetanomaximus8650 2 жыл бұрын

You're my hero!

@drmcole001 2 жыл бұрын

Great work as always. Your videos have helped me a ton. Any chance you could do a series on Power BI??

@Roger-mg8zh 2 жыл бұрын

Thanks 🙏 a big topic short and straight 😉👍

@blackmayza1 2 жыл бұрын

Great vid as always. Every time I watch one of your videos, I learn something new or a better way to do something.

@LeilaGharani 2 жыл бұрын

Glad to hear it!

@apritjain6668 2 жыл бұрын

@@LeilaGharani can we extract data with the help of advanced filter

@apritjain6668 2 жыл бұрын

@@LeilaGharani can we use conditional formatting

@apritjain6668 2 жыл бұрын

@@LeilaGharani can you reply right now

@maddymaddy281 2 жыл бұрын

YOU EXPLANTION IS SO GREAT I LEARN A LOT FROM YOUR VIDEOS

@lawrencekazibwe9751 2 жыл бұрын

Thanks Lisa, it has been very informative, keep it pse

@ashrafabdallaattyaelfeky2639 2 жыл бұрын

Excellent explanation and new ways to delete duplicate data. Thank you for your efforts. We are waiting for more videos and new ideas. I am a good follower of your channel and I am from Egypt Greetings to you