Three EASY Ways to Find and Remove Duplicates in Excel

[@LeilaGharani]

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

[@ekevanderzee9538]

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.

[@mayanksrivastava6085]

I Like you voice and speaking skills

[@thenotidevil]

Hope you focus on content too

[@mayanksrivastava6085]

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

[@Shuvoorahman]

@@mayanksrivastava6085 🤭🤭

[@colormile-vid8888]

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!

[@mcd22630]

Knowing that Power Query is case sensitive will be important to remember. Your t-shirt and bracelet combination were captivating.

[@LeilaGharani]

Thank you 😊

[@soundofmusic0613]

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

[@howdoicommentontcomopuedo9365]

This woman has the best tutoreials

[@PeterCharalambos]

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

[@Anastasia-wy1uj]

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

[@TPzita]

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

[@trinitys.7833]

thank you very much for sharing this, that's very helpful. And I've this way in my WPS Office, it also worked out and even by less steps! I just need to select the cell range> click "highlight dplicates"> choose "remove duplicates".

[@mattschoular8844]

Thanks Leila. In addition to dealing with the capitalization issue in PQ, I usually also TRIM the text fields to remove addition spaces... Thanks for sharing...

[@LeilaGharani]

👍

[@shironmania]

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

[@kroyhevia]

Exactly what I needed Thank you!

[@BillSzysz1]

Thanks Leila for the interesting lesson :-) One little note about PQ case - you don't need to add a step..... you can add second argument of Table.Distinct function. In this case it will be something like this below. = Table.Distinct(#"Changed Type", Comparer.OrdinalIgnoreCase)

[@DrChill2]

3 EASY Ways... ;)

[@HowToAnalyst]

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

[@blackmayza1]

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

[@LeilaGharani]

Glad to hear it!

[@apritjain6668]

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

[@apritjain6668]

@@LeilaGharani can we use conditional formatting

[@apritjain6668]

@@LeilaGharani can you reply right now

[@JLvatron]

Thank you for your great help!

[@smileycindy]

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

[@LeilaGharani]

You are so welcome!

[@bluesky0300]

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 .....

[@Ammar.mrm-2002]

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 :)

[@dianal3627]

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

[@Bokery1000]

Good one. Thanks!

[@RajeshBachuRadhika]

Leila! you are simply master of Excel

[@HadesTimer]

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

[@stingehte]

You deserve more followers. 95% of times I learn new things

[@lyfrocks5554]

One of the very talented person who deserves more subscribers

[@victoriasingveena441]

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

[@LeilaGharani]

Glad it was helpful!

[@vitor2650]

Leila you are a world class trainer! I get better each day I view your content.

[@LeilaGharani]

That's great to hear!

[@Mandelbrot567]

I am one of the people who asked Leila this question, so thanks for answering. I was wondering why I was getting different results in Power Query!

[@ozzy155]

I consider myself good in excel. But u r always better. Always learnt something new from you !

[@knowledgehub4192]

Very well explained, perfect way of making others understand.

[@gmbylsma]

You're such an effective teacher! Thank you!

[@bperez8656]

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

[@joefromdc]

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

[@thiago713]

Daaaaaaaaaang!!! I didn't think I was going learn on something so basic, I've been removing dups for years!!! but you never know what you don't know!!! #knowYourCase! #powerQuery4TheWin!

[@LeilaGharani]

Power Query rulezz :)

[@brucefogelstrom7985]

How about displaying the duplicates that were found and removed? I routinely use files that have 10-25k rows so being able to see what was removed would be very helpful. Great topic!

[@Audiovisual00]

Great video.I am not in a position to contribute at the moment. So watching all the ads without skipping.Keep going Madam.

[@leeannhadgis5985]

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

[@LeilaGharani]

You're very welcome, Leeann!

[@elactecnology]

The queen of Excel. What a wonderful video

[@LeilaGharani]

Glad you liked it!

[@nadermounir8228]

Thank you Leila. Great explanation 👌

[@maddymaddy281]

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

[@wayneedmondson1065]

Hi Leila. Great tips for removing duplicates from a data set. A fourth option is to use Advanced Filter and check "unique". These days, the UNIQUE function and Power Query are the goto methods for maximum flexibility and for dynamic results. Good to know many methods though. Did I get the job? Haha!! Thanks for the video :)) Thumbs up!! PS - Great reminder about case sensitivity in Power Query vs. other methods.. easy to forget that distinction.

[@LeilaGharani]

You sure did, Wayne 😁

[@MrLuckyuser]

Your way of explaining is awesome.

[@juanlara5613]

Thank you Leila... you just saved us a lot of hours of work

[@LeilaGharani]

You're welcome 😊

[@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..

[@muscleman0009]

Thanks for posting this...very needed!

[@ExcelWithChris]

Thanks! Especially showing how Power Query is case sensitive.

[@samanthadaroga4811]

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

[@LeilaGharani]

Our pleasure :)

[@davidwayne9982]

I agree with Mayank- love your voice.. and your teaching style-- such Great videos.. and I know I've said this before- probably will again- GOD, you are GORGEOUS !!! Wow. But thanks for the GREAT classes-- i learn so EASILY with your videos..

[@rewur615]

Danke!

[@LeilaGharani]

Thank you!

[@workinprogress5936]

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

[@dwyang2307]

You are the best teacher!

[@seanmcgrath5686]

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

[@TheStarvenger]

Love your videos... Please keep making such videos.

[@LeilaGharani]

Thank you, I will.

[@rahulrawat9301]

You are amazing.... seriously. Everytime, you bring something new to learn and explore and the way you speak is commendable....I really like your vides and it helps.

[@hasrulmuhammad8271]

Suwaeryuulhlebdh

[@hasrulmuhammad8271]

Ysraarweeryhas.

[@candymuncher8155]

You're my new hero.

[@davepeeters6518]

First method worked GREAT! Thanks

[@LeilaGharani]

Our pleasure!

[@Mu00lia]

You continuously update me. Thanks 👍

[@ashrafabdallaattyaelfeky2639]

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

[@jayholm9504]

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]

You're so welcome, Jay!

[@TK-rv7wq]

Jay holm,, where are you from?

[@__doe__]

Used this today following your steps, thanks a million! ❤️

[@LeilaGharani]

You're so welcome!

[@phpvbacoder9000]

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

[@carolina.data.analyst]

Thanks, i´m just clean some data for my university homework :) you help me a lot

[@mayorstheory]

Got what I needed in a sec. Thanks

[@dlep9221]

In each of your videos, i learn something. Thanks a lot !

[@LeilaGharani]

My pleasure!

[@ozzy155]

You are a champ leila. Truely

[@Luciano_mp]

Very good Leila. Thanks!

[@nashidmadathilkandypara9160]

I know the 3 methods for removing duplicates value But I don't know what are the difference between these methods Thank you liela .👍 You are amazing 👏❤

[@louis-philippetaschereau1944]

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

[@pieterkaruniadeo3494]

Thanks Leila. The best mentor

[@JonhHarvest]

You are a life saver. Definitely subscribed, thank you!

[@LeilaGharani]

Thanks for the sub!

[@m5ycgxboi250]

Love this short cuts

[@juanvalenzuelal1839]

The best ! Thank you Leila

[@VenusVvV]

I need just right these skills at work today!!

[@joydebghosal.7646]

Just awesome! Proud of you ma'am.

[@anv.4614]

Thank you. Well explained

[@bonguthandokhumalo7552]

Thank you so much, great lesson!

[@tifouraamina1761]

😍 thank you Leila you always save my life

[@TheBipin819]

Excellent and easy. Thanks 🙏

[@alonaisrael]

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

[@johkwalter9225]

Very helpful. Thank you Leila

[@veramoralez7870]

Thank you.. you explained it very well.👍

[@tomjun8945]

Very helpful video as always. Thank you so much.

[@LeilaGharani]

My pleasure!

[@mijoizagas3747]

Useful information, thank you!

[@mohamedgenidy1901]

thank you Leila .... you are the best

[@luckymutibo9848]

Grandmaster Leila..am learning n growing

[@deanoh6414]

Brilliant. Never knew about the UNIQUE function. That's the way to go I think if Excel version of the userbase permits. Saves Macros and setting of the Table refresh features. Nice one Leila.

[@donatopedone3796]

Ooo

[@donatopedone3796]

Lp

[@donatopedone3796]

Lllll

[@donatopedone3796]

Ll

[@LEGIONMAGAZINE]

Thank you, really productive video.

[@eslamfahmy87]

Clear and simple thank you

[@santoshtodkar4463]

Always learn new tools in your videos mam .... thank you so much mam

[@gaetanomaximus8650]

You're my hero!

[@rashiedasuliman4138]

Very helpful video once again Leila. Thank you

[@LeilaGharani]

My pleasure!

[@jackbench5427]

Super helpful, thanks a LOT.

[@ramen10lass78]

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

[@nouradiinabdirahmanmohamed3962]

Very useful in pretty interactive way. thank you. Greeting you from Somalia 🇸🇴.

[@LeilaGharani]

My pleasure :)

[@PhenomenalChezline]

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 👍🏾

[@keshoweatherz8499]

Very helpful, thank you

[@saxonmichaelopare4804]

You are the best!!

[@ManishKumar-qn9be]

Thankyou so much love from India 😊

[@kiranvootori8101]

It would help to know the impact of performance of using these. Especially unique function, because it seems to trigger for any cell edit.