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

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

[@cherrywang8971]

It's very helpful, easy and clear instructions! Thanks!

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

[@mugdhanaik7241]

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

[@alexmonterville6342]

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

[@MikeSandoz-ft9di]

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

[@aparnaperugupalli534]

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

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

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

[@EEZYEEEE]

wow an ehow video that is actually useful and works

[@ms.mollye4978]

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

[@simegnihtekle]

It was helpful sir, thank you!

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

[@nicholaskwan6275]

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

[@trevorjames1776]

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

[@easydater]

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

[@chatwithsubhra1]

Very nice ... Easily done .. Thanks Sir

[@dnyaneshwaryadav7407]

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

[@gamingfreak2141]

Hi sir, it was great to learn, Thanks!

[@josephgodwin7221]

It was so helpful Ted!, Thanks for sharing.

[@haseeb1504]

thank you sir. great video

[@tapiwaobert85]

THANKS YOU SAVED MY DAY

[@MHTonu]

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

[@sobeeberly7680]

Thank you! Saved me a lot of time :)

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

[@shahrukhnajeeb9853]

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

[@rymearts9746]

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

[@richardmckeon2453]

Thanks. That was very helpful.

[@akilas4357]

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

[@cindyhui6612]

Thank you so much 🙏🏻

[@muhammadusmanraja8336]

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

[@opbankolia]

It saved my time!! Thanks!!!!

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

[@missingdoc9604]

thanks you saved me

[@morganpoole9237]

Thank you!!!!

[@ScottFichter]

THANK YOU!

[@mrpips76]

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

[@togetherweexcel1525]

ua-cam.com/video/jxigPQqUufQ/v-deo.html

[@Shoyabakand]

Thanks, it really helped me a lot

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

[@rajeshwarshibi8728]

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

[@mohamedhussien5768]

thanks , this is really helpful and great

[@kristenbang6026]

Thanks, Ted! :)

[@fabiorego9507]

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

[@phgarner]

Thank you Ted

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

[@sumfeller73]

Still watching this in 2022.

[@loyal_support]

This is going to save my sister hours

[@togetherweexcel1525]

Valentine Da. Great ua-cam.com/video/jxigPQqUufQ/v-deo.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?

[@muralidhara4738]

thanks sir

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

[@truththroughlove1012]

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

[@santoshadhikari9933]

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