How to Remove Duplicates in Excel 

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

why you don't have a LOT more views is beyond me... one of the most simple, concise, and easy to follow vids out there. Made it so EVEN I could perform the task. Thanks!!

I have watch a lot of videos on removing duplicate values and they all explained well but you stand out simply because you never forget to zoom your screen so we can easily see what you are doing and you never ever forget to include the worksheet link file for us to download and practice with. God bless you for always including the file link and zooming your videos

I'm so happy I found this video.

Love the way you share your learnings with us u are the best.

Thank you Kevin for this.

Im cleaning a huge data set for my PMac final. This was most useful. Thanks my dude.

amazing teacher. Thank you!!

The UNIQUE function is what Ive been searching for. Thanks Kevin

This is brilliant! Odd that the unique formula was not introduced sooner! Amazing! Thanks

Good videos Kevin i enjoy how you explain things so well

Still an excellent video after 4 years!

Hello Kevin, This was very useful, thank you.

Thank you, Kevin

Hello Kevin, I would like to thank you for this video, I have a project at my new job to create a spreadsheet to compare cost. So, I am copying and paste cells that have duplicate item numbers and i know I will have to remove the duplicates cells one by one but I then I discovered and watch your video. Thank you!!!!

Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence

Does anyone knows how to search entire workbook and return all records which match a certain value from a drop down list with or without a Macro? e.g. if we have a list of many large organization in a worksheet and have a list of all of their employee, first name, last name, phone, email, title,..... ( many per organization) in another worksheet. How one can see the records of all employees in an organization by selecting the organization's name from a list or drop down box, etc. I would appreciate if your insights.

Thank you so much, this was very helpful but I wish I could know how to delete the unique values

Hi Kevin, when will the UNIQUE Function be available to us? I currently use 365 ProPlus Corporate version of excel. Many thanks!

Hi Kevin, Nice Tutorial. Sad to say i don't have this function in 2016 pro plus. So is there an other way to get the same result please. Thank you

You are an amazing teacher. Thank you!! Simple and super helpful.

Hi Kevin, I need to highlight several duplicate items across several rows with more than one color, no numbers. I do not need to deleted data. This is to identify which parts are used by model. Conditional format does not work due to multiple duplicates and large set of data. Thanks.

This video literally saved my @ss last night, thank man! Keep up the good work!

How do you sort multiple of the same values in sequential order.. so 6 fields contain 112233, how do you sort them 123123 ??

Is there a way to highlight and/remove duplicated names between 2 separate column and in separate order? for example, column1 "Ann Marie Sally" column 2 "Sally, Sue". These columns would be highlighted because the word "Sally".

Thank you

This was very useful. What if I want to keep the duplicate and delete the first entry?

thank you

Hey Kev, Thanks a lot for this. I was able to remove duplicated rows in multiple columns. However, my data was so repetitive that I didnt even know which one was original and which one was duplicate. Literally 4 columns with 4000 rows. Sometimes for column 2 rows, column 1 had duplicate rows, sometimes for column 2 rows, column 3 had duplicate rows, sometimes for column 3 rows, column 4 had duplicate rows, and basically just a whole mess. Its almost impossible to tell which data to delete and which one to keep in these 4 columns since I didnt have any background of the data, I just received it from corporate and now I’m supposed to clean it up. I couldnt say oh for column 1 this data doesnt match column 2 so maybe it should be removed? or for column 3, this data doesnt match to column 4, I have no idea what is what, but I’m supposed to make sense of it somehow. I deduced down 4000 rows into 20 rows with the help of delete duplicate rows but I think I quite literally deleted everything😂

Hi Kevin, did you ever record a video on how to create a timetable in Excel? That would help a lot. Thanks

Thank you! this helped me a ton!

Hi Kevin, how would I go about removing duplicate values in this scenario: “Product Description” “Product Size” “Stock on Hand Figure” example being something like this: “White Rice” “1kg” “0” and then duplicated “White Rice” “1kg” “5” now I want to remove all duplicates that have a Zero SOH figure? I hope that makes sense..

0:49 Highlight duplicate data 1:50 Remove duplicate data 2:57 List all unique items 4:38 Find values that show up once

Hello I like your vids I’ve been watching u since the how to record screen and webcam and that vid was helpful

Hello Kevin, Hope you are doing well! How can I only delete the second duplicate but keep the first one? Say I have over 300 items I know they are duplicated maybe one or three times on my spreadsheet but I still want to keep one of them. How can I keep one and delete all the others? Thank you!

all your videos I've watched have been very helpful. The duplicate delete video was great but I need help moving it a step further. Example, I have an excel list with over 5000 rows of contact info and a dozen columns wide. After highlighting the duplicate emails through the column filter, I show approximately 15-20% of the worksheet are duplicates. Now I want to delete all the duplicate Rows of contacts within that group without messing up / rearranging column data in the entire worksheet (as has happened in the past). It's a bit more complex but I'm guessing you know how. Can you please explain?

Hi I need help where I have 1 sheet of shares, buy/sell, amt ,no of shares and on the 2 sheet I have to find what stocks are currently active i.e. in previous sheet there will be lot of buy and sell entries but i need what is the total for each stock in 2 sheet howmuch stock I with hold im running excel 2016 please suggest me how to go about with that...

MS god lol thank you Kevin!

Hi Kevin, looking at the last sheet Multiple Columns, is there a way to highlight those in the original data set? In other words, the conditional formatting for duplicate values, but then for multiple columns? Our a workaround? Greatly appreciated. Can't use power query to start left matching on two fields because my user community uses excel for web, and then they get not-supported messages, which is very annoying.

Loved this and yet it didn’t work for me. Followed stop by step. Tons of duplicates on my page and it found 4 and when I went to remove duplicates it said there were none.

Hi kevin , how to select the opposite result of unique function ?

How can i remove duplicate entries from 10 Millions data? I want to remove in one click plz guide

What if I have duplicate values in a column but that's not what I'm after, but duplicate values across two columns. In more details, I will like to ONLY highlight duplicates across two different columns and not within the same column. Is there a way to go about this?

Hello Kevin. I run a subscription service and have all my subscribers in a table. I need to create a control table to keep track of their colour 'likes' and 'dislikes'. The cells have all different values obviously have all different values based on their preferences. Which formula can I use that will include all cells that include but are not exclusively equal to one colour. Thank you!

How do you delete a table in excel... please do video

That's good, but I gotta say user interface of WPS Office is more intuitive and user-friendly compared to Microsoft Office, especially for basic tasks. take this as example, if I want to find or highlight or remove duplicates, I only take 2 steps: 1. select the range of your values 2. click “highlight duplicates”< “set” or 2. click “highlight duplicates”< “remove duplicatess”

how do i stop duplicated box via date : box E0 1/08/23 box E0 2/08/23 so if this to be duplicated by box and date how do i stop that ?

How different is "office on the web" from office 365?

how do I disable the option to detect duplicate values ​​in excel - how do I disable this option - I want to have duplicate values????

How do I prevent duplicate in a range

How do you remove duplicate rows? I have 11000 line items and I'd like to remove duplicate rows.

How to find duplicate from different sheets

Sooo awesome

Wow, there's a command called "Remove Duplicates"! Who knew?

Om shanti

UNIQUE function is ONLY available in 365! this is BS!