Easily Remove Duplicates with these functions

Easily Remove Duplicates with these functions - Excel Data Cleaning 🧹

Рет қаралды 14,473

Күн бұрын

Need to clean up data and remove duplicates?
Need to clean up data and remove duplicates?
You've come to the right place.
In this video, learn how to deal with 5 kinds of duplication scenarios in your data and how to deal with them in Excel using various functions +features.
⏱ Topics in this video:
===================
0:00 - 5 kinds of duplicate data in Excel
0:47 - (1) Removing duplicates with the "Remove Duplicate" button in Excel
1:12 - Identifying (highlight) duplicate values in Excel
1:41 - Removing duplicates with a formula - UNIQUE function
2:18 - (2) Removing Duplicate combinations
3:11 - (3) Duplicate values comma separated in a cell - using TEXTSPLIT & UNIQUE functions
5:48 - (4) Removing duplicates but keeping the latest data - manual approach
7:19 - Removing duplicates but keeping the latest data - formula approach
9:56 - (5) Removing duplicates spread across two lists
11:05 - But what if your data is somewhere else, not in Excel?
📁 Sample file:
=============
Practice your data cleaning skills with this remove duplicates workbook -
chandoo.org/wp/wp-content/upl...
📺 Other Data Cleaning Videos
==========================
Drowning down in dirty data?
Refer to my...
Valuable videos for vigorous vacuuming
How to use Power Query in 15 minutes - • Learn Power Query & Au...
Data Cleaning in Excel - 10 Tricks - • Data Cleaning in Excel...
Data Cleaning in Excel - 10 PRO Tricks - • Data cleaning in Excel...
Text and Numbers mixed up - use this potion - • Data Cleaning PRO Tip:...
How to clean, analyze and present data (masterclass) - • How to Clean, Analyze ...
💥 Full Data Cleaning + Advanced Excel course - chandoo.org/wp/excel-school-p...
~
#Excel #datacleaning #duplicate

Пікірлер: 34

@_YOUTUBEMAN 14 күн бұрын

Thanks Chandoo for consistently uploading quality content! You helped me land my first Data Analyst job. Thank you so much!

@chandanakollu2555 14 күн бұрын

how did you do it help us in achieving

@_YOUTUBEMAN 14 күн бұрын

@@chandanakollu2555I practiced along with the video playing on my second monitor. I started with the beginner to advanced data analyst playlist on chandoo’s channel. Kept on practicing by downloading Awesome chocolates dataset. Then I headed over to power Bi course on his channel. It helped me in learning how to create attractive looking dashboards. It took me around 7 months of consistent practice.

@thonguyenvu967 8 күн бұрын

wow! I have got my answer after watching ur video. Thanks you so much, teacher

@riyazahmedsyed271 14 күн бұрын

Thanks for the good and very frequently used function. Apart from removing duplicate, you also gave a nugget on how to lookup values meeting multiple conditions using *. I was struggling all the time but its a simple hack.

@muralik98 2 күн бұрын

really practical use cases

@santoshdevadula5071 13 күн бұрын

Thanks Chandoo, I learnt an extension of an existing solution I already have.. I worked with names and latest data scenarios. As of now I am using an intermediate column called Key with concatenation of name and latest date and used lookup to get remaining columns.. now I can use filter..

@TrekwithIslam 14 күн бұрын

Just see the names of the people in the tables. Good one Chandoo 🤣

@viktorasgolubevas2386 13 күн бұрын

Quality and educational content, as always. Thanks a lot! Ex4: In case of daily granularity of data I simply would use pattern =FILTER(NamesDates_ ,Dates=MAXIFS(Dates,Names,Names))

@chandoo_ 13 күн бұрын

Wow, excellent use of the array option in MAXIFS... took me a minute to understand what is going on.

@TheUnknowns90637 14 күн бұрын

Thanks for sharing, everything you share is valuable in many ways

@sathyakumarkotta4849 14 күн бұрын

Thank you, Chandoo, really help.

@lavanyachinthapatla9468 12 күн бұрын

Super chandoo sir ty

@daudi4793 14 күн бұрын

Vstack is new for me. Thank you. Might use it later in data cleaning.

@chrism9037 14 күн бұрын

Thanks Chandoo!

@ihgamingfun6295 14 күн бұрын

Excellent bro 👍👍

@ajaykumar_7__ 13 күн бұрын

Sir could you please put video about data scraping which we can use those data for analysis and do some projects

@VenkateshJinukala 14 күн бұрын

🙏🙏🙏 useful functions👍 Thanks a lot Chandoo Garu

@manikantamani7849 14 күн бұрын

Complete exel video ఒకటి telugu lo chey anna

@bhanupradeep3337 10 күн бұрын

Thanks brother.. could you please share any personal budget template

@rasheedkk8798 14 күн бұрын

needed, searching for it ..

@anushetti8452 14 күн бұрын

Sir do a video on VLOOKUP,HLOOKUP, PIVOT TABLE

@hasangul1974 14 күн бұрын

UNIQUE formula is also available on MS Excel 2021

@chandoo_ 14 күн бұрын

That is good to hear. I haven't used Excel 2021 but I know XLOOKUP is in there.

@banday78 14 күн бұрын

How to separate duplicates in another column?

@ciaucia156 14 күн бұрын

=UNIQUE(FILTER(Names,COUNTIF(Names,Names)>1))

@banday78 11 күн бұрын

@@ciaucia156 thank u

@kameshsharma5164 7 күн бұрын

Hello Sir, I need your help. I want a formula that if • if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated • If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated • if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated Please Reply Sir

@rajeevgosavi4514 8 күн бұрын

Are Yaar kabhi to kuch free excel video dala karo, Hamesha aap paisa maangte rahte ho. Aapke video dekhne ke baad mein hi pata chalega ki aapka sikhane ka style kya hain. Uske pahe hum invest kaise kare?