How to Remove Duplicates in Excel

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

I'm so happy I found this video.

amazing teacher. Thank you!!

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!

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.

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 ?

@kevinStratvert

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

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

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

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.

How do I prevent duplicate in a range

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

Thank you Kevin for this.

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

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

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

Thank you, Kevin

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

How to find duplicate from different sheets

Thank you! this helped me a ton!

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

Om shanti

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

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

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?

Sooo awesome

Hey Kevin, I need to delete duplicate words within all highlighted cells. What can i do for this?

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

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

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?

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.

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😂

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

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!

Good videos Kevin i enjoy how you explain things so well

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.

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

MS god lol thank you Kevin!

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

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

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

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 so much, this was very helpful but I wish I could know how to delete the unique values

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

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

thank you

Hello Kevin,
This was very useful, thank you.