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

Subscribe Now:
www.youtube.com...
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!

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

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

[@mugdhanaik7241]

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

[@simegnihtekle]

It was helpful sir, thank you!

[@MikeSandoz-ft9di]

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

[@alexmonterville6342]

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

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

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

[@haseeb1504]

thank you sir. great video

[@trevorjames1776]

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

[@aparnaperugupalli534]

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

[@ms.mollye4978]

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

[@easydater]

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

[@EEZYEEEE]

wow an ehow video that is actually useful and works

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

[@nicholaskwan6275]

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

[@sobeeberly7680]

Thank you! Saved me a lot of time :)

[@chatwithsubhra1]

Very nice ... Easily done .. Thanks Sir

[@gamingfreak2141]

Hi sir, it was great to learn, Thanks!

[@missingdoc9604]

thanks you saved me

[@MHTonu]

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

[@morganpoole9237]

Thank you!!!!

[@tapiwaobert85]

THANKS YOU SAVED MY DAY

[@josephgodwin7221]

It was so helpful Ted!, Thanks for sharing.

[@dnyaneshwaryadav7407]

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

[@shahrukhnajeeb9853]

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

[@sumfeller73]

Still watching this in 2022.

[@richardmckeon2453]

Thanks. That was very helpful.

[@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 ?

[@akilas4357]

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

[@cindyhui6612]

Thank you so much 🙏🏻

[@mohamedhussien5768]

thanks , this is really helpful and great

[@opbankolia]

It saved my time!! Thanks!!!!

[@muhammadusmanraja8336]

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

[@ScottFichter]

THANK YOU!

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

[@Shoyabakand]

Thanks, it really helped me a lot

[@phgarner]

Thank you Ted

[@jhaneyu4563]

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

[@kristenbang6026]

Thanks, Ted! :)

[@fabiorego9507]

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

[@muralidhara4738]

thanks sir

[@santoshadhikari9933]

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

[@rymearts9746]

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

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

[@rajeshwarshibi8728]

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

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

[@ridesharetucson]

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

[@mrpips76]

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

[@togetherweexcel1525]

ruclips.net/video/jxigPQqUufQ/видео.html

[@loyal_support]

This is going to save my sister hours

[@togetherweexcel1525]

Valentine Da. Great ruclips.net/video/jxigPQqUufQ/видео.html

[@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?

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

[@truththroughlove1012]

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

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

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

[@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 RUclips to improve their algorithm ;-)