How to Delete Duplicate Rows From a List in Excel or Microsoft Office Online : Using MS Excel

Subscribe Now:
kzbin.info_c...
Watch More:
/ ehowtech
Deleting duplicate rows from a list in Excel is something that is very tedious if you do it manually - luckily you don't have to. Delete duplicate rows from a list in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Expert: Edward Russell
Filmmaker: Patrick Russell
Series Description: Microsoft Excel is a very valuable spreadsheet tool that comes with all versions of Microsoft Office. Get tips on using Microsoft Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video series.

[@truththroughlove1012]

I've been searching high and low for this specific feature and you are the only one who has given a solid answer. Thanks a ton!

[@GearsBusinessSolutions]

Excellent Pat - especially shift control and past special value! I was attempting to sort with the formula still there and it was completely screwed up. your solution worked perfect. thank you. big thumbs up

[@hartbeepsnorthcheshire1139]

This was SOOOO helpful! My 2008 MAC Excel didn't like 4 values being tested for duplicates, I tried with 3 and it worked. I also had to copy and paste my data from a downloaded data sheet because it wouldn't show the result of the formula. So I copied and pasted values only. Then it all worked x

[@ms.mollye4978]

So thankful for this tutorial. It saved me HOURS of time!

[@chrisdc22]

Thank you!!!! Got a spreadsheet with 7,000 addresses and this was IMMENSELY helpful!!!! No telling how much you saved us on postage.

[@tableau179]

You might wanna pay it forward - Keep Excelling!

[@nicholaskwan6275]

Helped a ton, have been wondering a quick and easy way to do this for a while!

[@alexmonterville6342]

Thank you for this. This is the only reasonable way to do this that I've found online

[@mugdhanaik7241]

Superb! This is such a quick help! Thanks a ton

[@sobeeberly7680]

Thank you! Saved me a lot of time :)

[@josephgodwin7221]

It was so helpful Ted!, Thanks for sharing.

[@shahrukhnajeeb9853]

Thanks for the amazing video. Keep up the great work!

[@MHTonu]

Great thanks. It's really worth-full that I was looking for.

[@mohamedhussien5768]

thanks , this is really helpful and great

[@MikeSandoz-ft9di]

Wow. Simply wow. Amazing video. Saved me hours.

[@richardmckeon2453]

Thanks. That was very helpful.

[@opbankolia]

It saved my time!! Thanks!!!!

[@simegnihtekle]

It was helpful sir, thank you!

[@Shoyabakand]

Thanks, it really helped me a lot

[@akilas4357]

its really useful to viewers, thank you !!! :)

[@aparnaperugupalli534]

It worked for me, you have saved my day Thankyou!!!

[@trevorjames1776]

TED..... YOU ARE THE MAN! THANKS

[@muhammadusmanraja8336]

Was just looking for that,,,,,,Perfect

[@kk-op8qr]

Hi, thank you so much.. Can you post a video for excel to delete rows giving a condition as in IF statement if it exists ?

[@chatwithsubhra1]

Very nice ... Easily done .. Thanks Sir

[@gamingfreak2141]

Hi sir, it was great to learn, Thanks!

[@dnyaneshwaryadav7407]

I was searching remove duplicate entry's. Thanks for solution.

[@ScottFichter]

THANK YOU!

[@EEZYEEEE]

wow an ehow video that is actually useful and works

[@tapiwaobert85]

THANKS YOU SAVED MY DAY

[@haseeb1504]

thank you sir. great video

[@geneplugovoy]

great video i was searching for removal of duplicate rows rather than just duplicate data in the column thanks...

[@tableau179]

Ahhh---this is about duplicate rows not columns!

[@kristenbang6026]

Thanks, Ted! :)

[@phgarner]

Thank you Ted

[@easydater]

I was afraid i had to go back to my high school notes and study MS Access all over again. Thanks man

[@cindyhui6612]

Thank you so much 🙏🏻

[@morganpoole9237]

Thank you!!!!

[@rishimitranath]

I completely agree, this is the logical approach. U hit the nail on the head.

[@tableau179]

What did you hit your head on?

[@rishimitranath]

Reread n try n understand

[@missingdoc9604]

thanks you saved me

[@rymearts9746]

What if I remove duplicate of attlogs in biometric?? I remove time in and time out of my employee

[@muralidhara4738]

thanks sir

[@StopForeclosureMortgage]

what if I want to find duplicate addresses and remove them but some of them have different names, like spouses with the same address and just leave one spouce connected to that address

[@jhaneyu4563]

I want to delete both duplicate and original. For all rows that have duplicates, how can you delete both duplicate and original row?

[@ridesharetucson]

does not work if you have to match the contents of the previous field

[@sumfeller73]

Still watching this in 2022.

[@fabiorego9507]

Good Video for duplicates only. If there are 3 of the same cells it breaks the whole thing.

[@mrpips76]

Awesome video. Not working for excel 2016. All cells are saying not duplicate; but i have tons of duplicates.

[@togetherweexcel1525]

kzbin.info/www/bejne/oKnMmIOHprqonLM

[@santoshadhikari9933]

If it were not arranged alphabetically how would we have done it?

[@rajeshwarshibi8728]

I got a doubt...what if C2 is not equal to C3

[@fidelfilpo37]

Your method will delete important information if the list contains more than one duplicate, if you have three or more equal lines your method will delete all you will not keep the "not duplicate" line. What you need to find is how to delete only the duplicated values without shifting the cells in a column.

[@supercollectionstudio5572]

You can highlight or delete duplicated or identical rows easily using Dose for Excel Add-In which provides more than +100 Features, check their website in below: www.zbrainsoft.com/excel-delete-rows.html

[@loyal_support]

This is going to save my sister hours

[@togetherweexcel1525]

Valentine Da. Great kzbin.info/www/bejne/oKnMmIOHprqonLM

[@tableau179]

What about your cousin or aunt? How many hours do you reckon its gonna save your generation?

[@loyal_support]

@@tableau179... bro it's been three years wtf?

[@truththroughlove1012]

I also found it worked better for my data to use =if(OR(A1=A2,OR(A2=A3)),"duplicate","not duplicate")

[@fidelfilpo37]

Regarding my previous comment, you can confirm that your method is wrong and dangerous when in a list you have data duplicated three times or more, because using your method in your list that originally contained the name of "Combs, Earle" since you have it listed three times it will not be shown after your procedure, it will be completely removed from your list not only the duplicate values in lines or rows. You are near but not "there" with the solution.

[@nicholashayden9931]

There is a delete duplicate button that does this for you in excel 2016

[@truththroughlove1012]

The delete duplicate button does not take into factor everything else in the table. This feature allows to maneuver around dozens of columns and remove duplicates without unorganizing.

[@Volodyalipkin]

Incorrect method. For example, let you have three records (csv) Alex,USA,..... Alex,Canada,.... Alex,USA,..... If you sort by name only, this order will be not changed. In this case algorithm not catch equal 1 and 3 lines.

[@MichaelGuy]

NOT DELETE..... How to duplicate rows..... so frustrating when you get a video that deals with the OPPOSITE of what you searched for.

[@tableau179]

Feel your pain bro - need to write to KZbin to improve their algorithm ;-)