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

Subscribe Now:

Watch More:

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.

[truththroughlove]

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!

[chrisdc]

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

[cherrywang]

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

[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

[supercollectionstudio]

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:

[mugdhanaik]

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

[hartbeepsnorthcheshire]

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

[MikeSandoz-ftdi]

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

[alexmonterville]

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

[ms.mollye]

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

[dnyaneshwaryadav]

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

[aparnaperugupalli]

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

[nicholaskwan]

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

[EEZYEEEE]

wow an ehow video that is actually useful and works

[chatwithsubhra]

Very nice ... Easily done .. Thanks Sir

[rishimitranath]

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

[MHTonu]

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

[kk-opqr]

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 ?