How to Remove Duplicate Data in Excel 2010 Spreadsheet

During this Microsoft Excel 2010 training tutorial video, learn how to remove duplicate records in a spreadsheet when working with Microsoft Excel 2010.

Stay in touch:

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

[sajeevvillody]

HI i need to delete two same names, i use duplicate , but it remove only one name, i need to remove both names . Example ( boby, steve, jeff, steve, evan, eric ) need to delete both steve names . any formula please.

[ArthurVanYoung]

What if the duplicates are in more than 2 rows. for instance, 1, 2, and 3. instead of 1 and 2

[cyberheo]

What happen if a cell has duplicate. Ex; a cell contains "Bike, bike, bike". How do you remove the 2 "Bike"

[lisachuck]

You can tell excel to not look in formulas when using the Find feature

[jasonpuckett]

BUT, if you sort by column B now, all of your duplicate cells will turn to 0.

[altavistasfo]

great tutorial but under 3 minute instructions took you 9 minutes. a lot of waste of time there. most of use look for direct to the point instructions. thanks