Grab the file I used in the video from here 👉 pages.xelplus.com/remove-duplicates-methods-file
@ekevanderzee95383 жыл бұрын
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.
@BillSzysz13 жыл бұрын
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)
@DrChill23 жыл бұрын
3 EASY Ways... ;)
@colormile-vid88883 жыл бұрын
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!
@mayanksrivastava60853 жыл бұрын
I Like you voice and speaking skills
@thenotidevil3 жыл бұрын
Hope you focus on content too
@mayanksrivastava60853 жыл бұрын
@@thenotidevil..... Like you are focusing on other people comments 😀
@Anastasia-wy1uj3 жыл бұрын
Pls make a video on finding, keeping and distinguishing between duplicates. 😊
@HowToAnalyst3 жыл бұрын
Awesome techniques to remove duplicates! Pivot tables are another way to remove duplicates because they de-duplicate items in the rows and columns pane.
@mcd226303 жыл бұрын
Knowing that Power Query is case sensitive will be important to remember. Your t-shirt and bracelet combination were captivating.
@LeilaGharani3 жыл бұрын
Thank you 😊
@wayneedmondson10653 жыл бұрын
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.
@LeilaGharani3 жыл бұрын
You sure did, Wayne 😁
@TPzita2 жыл бұрын
I use all this tools all the time, and I still learned something new … impressive :)
@dianal36272 жыл бұрын
Thanks. This was great. You can also use Conditional formatting to identify duplicates then remove them.
@brucefogelstrom79852 жыл бұрын
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!
@mattschoular88443 жыл бұрын
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...
@LeilaGharani3 жыл бұрын
👍
@blackmayza13 жыл бұрын
Great vid as always. Every time I watch one of your videos, I learn something new or a better way to do something.
@LeilaGharani3 жыл бұрын
Glad to hear it!
@apritjain66682 жыл бұрын
@@LeilaGharani can we extract data with the help of advanced filter
@apritjain66682 жыл бұрын
@@LeilaGharani can we use conditional formatting
@apritjain66682 жыл бұрын
@@LeilaGharani can you reply right now
@bluesky03003 жыл бұрын
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 .....
@PeterCharalambos Жыл бұрын
It's obvious..... I can't live without you. Even MS wasn't as clear as you
@soundofmusic06132 жыл бұрын
I've always relied on your videos everytime I want to learn something new in Excel. Thanks!
@shironmania2 жыл бұрын
Not only the formulas are dynamic, even you are. Very useful vid indeed
@smileycindy2 жыл бұрын
Fabulous demonstration! Loved seeing the results side by side with the differences. Thanks!
@LeilaGharani2 жыл бұрын
You are so welcome!
@nashidmadathilkandypara91603 жыл бұрын
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 👏❤
@Mandelbrot5673 жыл бұрын
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!
@trinitys.78334 ай бұрын
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".
@jayholm95043 жыл бұрын
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!
@LeilaGharani3 жыл бұрын
You're so welcome, Jay!
@TK-rv7wq3 жыл бұрын
Jay holm,, where are you from?
@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..
@Ammar.mrm-20022 жыл бұрын
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 :)
@kroyhevia3 жыл бұрын
Exactly what I needed Thank you!
@victoriasingveena4419 ай бұрын
Thanks Leila this is useful for a young Data Analyst like me. 😊
@LeilaGharani9 ай бұрын
Glad it was helpful!
@HadesTimer2 жыл бұрын
This is great, it's going to speed up my workflow so much. Thank you.
@joefromdc2 жыл бұрын
Great Point with PQ, Change the 'Format' simple but effective. Thanks for this tip
@knowledgehub41923 жыл бұрын
Very well explained, perfect way of making others understand.
@phpvbacoder90002 жыл бұрын
Learned to solve things much easier with your Videos 👍 I used adodb and a group by query in vba for this before.
@vitor26503 жыл бұрын
Leila you are a world class trainer! I get better each day I view your content.
@LeilaGharani3 жыл бұрын
That's great to hear!
@gmbylsma2 жыл бұрын
You're such an effective teacher! Thank you!
@bperez86562 жыл бұрын
You’re very handsome. Do you have an IG?
@leeannhadgis59853 жыл бұрын
Thank you! You are an excellent teacher and your content is so useful!
@LeilaGharani3 жыл бұрын
You're very welcome, Leeann!
@mohamed.montaser3 жыл бұрын
you can use pivot tables also to remove duplicates
@89SHIRU2 жыл бұрын
All Hail Queen Leila!👸🙏
@user-tm1eq8rz5s3 жыл бұрын
Good one. Thanks!
@Perfectsound882 жыл бұрын
Great video.I am not in a position to contribute at the moment. So watching all the ads without skipping.Keep going Madam.
@thiago7133 жыл бұрын
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!
@LeilaGharani3 жыл бұрын
Power Query rulezz :)
@ExcelWithChris3 жыл бұрын
Thanks! Especially showing how Power Query is case sensitive.
@ashrafabdallaattyaelfeky26393 жыл бұрын
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
@davidwayne99823 жыл бұрын
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..
@jagannathbenaka80423 жыл бұрын
My solute to your valuable solutions/suggestions
@LeilaGharani3 жыл бұрын
Thank you!
@PhenomenalChezline3 жыл бұрын
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 👍🏾
@RajeshBachuRadhika2 жыл бұрын
Leila! you are simply master of Excel
@stingehte2 жыл бұрын
You deserve more followers. 95% of times I learn new things
@rohitjha62483 жыл бұрын
Another informative video. Nice to know the fundamental difference while applying the unique and power query for removing duplicate records.
@ozzy1553 жыл бұрын
I consider myself good in excel. But u r always better. Always learnt something new from you !
@lyfrocks55543 жыл бұрын
One of the very talented person who deserves more subscribers
@samvan77872 жыл бұрын
Always enjoy your video - short, concise, to the point with real example, and don't waste anytime.👍
@maddymaddy2812 жыл бұрын
YOU EXPLANTION IS SO GREAT I LEARN A LOT FROM YOUR VIDEOS
@kiranvootori81013 жыл бұрын
It would help to know the impact of performance of using these. Especially unique function, because it seems to trigger for any cell edit.
@Maya-sv1pz3 жыл бұрын
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!
@samanthadaroga4811 Жыл бұрын
This was quite an instrumental video for my work needs. Thank you kindly Leila!
@LeilaGharani Жыл бұрын
Our pleasure :)
@juanlara56132 жыл бұрын
Thank you Leila... you just saved us a lot of hours of work
@LeilaGharani2 жыл бұрын
You're welcome 😊
@MrLuckyuser3 жыл бұрын
Your way of explaining is awesome.
@msbutterfly7142 жыл бұрын
I was only able to utilize the first one as I do not have the other two programs. But hey, it worked. Thank you
@elactecnology2 жыл бұрын
The queen of Excel. What a wonderful video
@LeilaGharani2 жыл бұрын
Glad you liked it!
@carolina.data.analyst Жыл бұрын
Thanks, i´m just clean some data for my university homework :) you help me a lot
@ManishKumar-qn9be2 жыл бұрын
Thankyou so much love from India 😊
@nadermounir82283 жыл бұрын
Thank you Leila. Great explanation 👌
@svenchik2 жыл бұрын
There is one more more manual but sometimes handy way to spot duplicates via conditional formatting, it will highlight your duplicates so you can see if there are duplicates and you can decide what to do about them.
@muhammadalirasheed55972 жыл бұрын
but removing manually it's more time taking, if you have larger data😢
@whaheydelee3 жыл бұрын
Thank you Leila for another excellent presentation. Another method of removing duplicates is using Conditional Formatting and filtering by color, no?
@TechTeacherTT2 жыл бұрын
👍👍👍
@swake18223 жыл бұрын
I like the latter options as then you don't actually touch the original data. As someone who deals with a lot of other people's sloppy data entry, I wish they would add a simple function for the compound task of - Remove trailing and leading spaces and convert case (choice:lowercase/uppercase/sentencecase/titlecase)
@rahulrawat93013 жыл бұрын
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.
@hasrulmuhammad82713 жыл бұрын
Suwaeryuulhlebdh
@hasrulmuhammad82713 жыл бұрын
Ysraarweeryhas.
@luckymutibo98482 жыл бұрын
Grandmaster Leila..am learning n growing
@imabdulmannan3 жыл бұрын
Unique Function Is Outstanding
@m5ycgxboi250 Жыл бұрын
Love this short cuts
@yousrimostafa69622 жыл бұрын
Thanks very much
@seanmcgrath5686 Жыл бұрын
Thanks for the quick and easy tutorial! you just saved me a ton of time!
@user-tf7te5fs2n3 жыл бұрын
We want more video like this, the video that can help us in tests and interviews Thank you for the video💕
@teoxengineer3 жыл бұрын
And the fourth and fifth ones are: 4-) Using conditional formatting to detect duplicates and then erase them. 5-) Using Filter Function like =FILTER(A1:A10,COUNTIF(A1:A10,A1:A10)
@LeilaGharani3 жыл бұрын
👍
@freesunsystemstutorial74113 жыл бұрын
It’s very nice video, especially when you are dealing with a lot of data
@LeilaGharani3 жыл бұрын
Glad you like it.
@VenusVvV3 жыл бұрын
I need just right these skills at work today!!
@dlep92213 жыл бұрын
In each of your videos, i learn something. Thanks a lot !
@LeilaGharani3 жыл бұрын
My pleasure!
@Innovative_Talks-UnlockChanges2 жыл бұрын
Hi Leila. I am your top most fan. I like your way of expression, sharpness, dedication and subject matters. I want to connect you somehow and that is why I subscribed your channel. You are true beauty.
@anv.46142 жыл бұрын
Thank you. Well explained
@deanoh64142 жыл бұрын
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.
@donatopedone37962 жыл бұрын
Ooo
@donatopedone37962 жыл бұрын
Lp
@donatopedone37962 жыл бұрын
Lllll
@donatopedone37962 жыл бұрын
Ll
@mayorstheory Жыл бұрын
Got what I needed in a sec. Thanks
@veramoralez78702 жыл бұрын
Thank you.. you explained it very well.👍
@lohitr92162 жыл бұрын
Thank you. Easily understood 👌
@__doe__ Жыл бұрын
Used this today following your steps, thanks a million! ❤️
@LeilaGharani Жыл бұрын
You're so welcome!
@TheStarvenger3 жыл бұрын
Love your videos... Please keep making such videos.
@LeilaGharani3 жыл бұрын
Thank you, I will.
@workinprogress5936 Жыл бұрын
Thank you for this, this is exactly what I was looking for.
@tomjun89453 жыл бұрын
Very helpful video as always. Thank you so much.
@LeilaGharani3 жыл бұрын
My pleasure!
@LEGIONMAGAZINE2 жыл бұрын
Thank you, really productive video.
@adohamisu1015 Жыл бұрын
Laila I love your videos, they are very educative
@rashiedasuliman41382 жыл бұрын
Very helpful video once again Leila. Thank you
@LeilaGharani2 жыл бұрын
My pleasure!
@dwyang23073 жыл бұрын
You are the best teacher!
@Freemarkets12362 жыл бұрын
Great! One other method I prefer most of the time is putting the data in the the rows of a pivot table.
@santoshtodkar44633 жыл бұрын
Always learn new tools in your videos mam .... thank you so much mam
@tifouraamina17613 жыл бұрын
😍 thank you Leila you always save my life
@muscleman00092 жыл бұрын
Thanks for posting this...very needed!
@mijoizagas3747 Жыл бұрын
Useful information, thank you!
@nouradiinabdirahmanmohamed39623 жыл бұрын
Very useful in pretty interactive way. thank you. Greeting you from Somalia 🇸🇴.
@LeilaGharani3 жыл бұрын
My pleasure :)
@louis-philippetaschereau19442 жыл бұрын
Very clear and handy. Editing is great. Thank you.
@keshoweatherz84992 жыл бұрын
Very helpful, thank you
@1989JordanMega Жыл бұрын
thank you very much.. your videos are really helping me at work.
@LeilaGharani Жыл бұрын
Glad you like them!
@lanrebolaji-owonifari33212 жыл бұрын
Great Info Leila. Do you have any info on how to "Extract" those duplicates into another table instead of removing them?
@johnmarsh30693 жыл бұрын
Thank you for sharing. Very informative, especially the difference between power query and the more traditional remove duplicate function in excel.