Easily Remove Duplicates with these functions - Excel Data Cleaning 🧹

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

[@_YOUTUBEMAN]

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

[@chandanakollu2555]

how did you do it help us in achieving

[@_YOUTUBEMAN]

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

[@TrekwithIslam]

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

[@riyazahmedsyed271]

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.

[@trendzinfluenza4782]

Excellent resource for honing your Excel skills! It is clear and informative, greatly speeding up my spreadsheet tasks. This skill boost is sure to be beneficial in career.

[@thonguyenvu967]

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

[@santoshdevadula5071]

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

[@muralik98]

really practical use cases

[@viktorasgolubevas2386]

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_]

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

[@TheUnknowns90637]

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

[@daudi4793]

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

[@sathyakumarkotta4849]

Thank you, Chandoo, really help.

[@VenkateshJinukala]

🙏🙏🙏 useful functions👍 Thanks a lot Chandoo Garu

[@chrism9037]

Thanks Chandoo!

[@ihgamingfun6295]

Excellent bro 👍👍

[@lavanyachinthapatla9468]

Super chandoo sir ty

[@manikantamani7849]

Complete exel video ఒకటి telugu lo chey anna

[@ajaykumar_7__]

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

[@bhanupradeep3337]

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

[@anushetti8452]

Sir do a video on VLOOKUP,HLOOKUP, PIVOT TABLE

[@rasheedkk8798]

needed, searching for it ..

[@hasangul1974]

UNIQUE formula is also available on MS Excel 2021

[@chandoo_]

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

[@entrustedhub]

Greetings
I don't know if you would understand my question and is as follows:
How do I handle zeros in spill functions, when it is supposed to be blank, or when my answer is zero or has a zero?
😢😢😢😊

[@chandoo_]

Can you give me a specific example and what outcome you are expecting?

[@kameshsharma5164]

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

[@banday78]

How to separate duplicates in another column?

[@ciaucia156]

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

[@banday78]

@@ciaucia156 thank u

[@rajeevgosavi4514]

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?