How to Delete Duplicate Text Entries in Excel : Using Excel

Subscribe Now:

Watch More:

Deleting duplicate text entries in Excel is especially useful if you're working with a very large list. Delete duplicate text entries 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: If you're looking for a powerful spreadsheet creation tool, look no farther than Microsoft Excel. Get tips on Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video series.

[Sizuedeals]

I struggled for up to 20 mins but now it is over, Bless you Sire

[BSBMteam]

2:23 =if(B3=B2, "Y", "N")

[venrickace]

THAT REALLY HELPED ME, Thank you so much

[vikasmohan]

Very well explained. Thank you so much!!

[kporterutley]

Thank you! You just saved me a lot of time!

[sushantbharti]

I am very thankful for such a helpful presentation

[NaveedKhan-fcmm]

Thank you very much! I was really stucked to filter a big data and you helped me out! :)

[chhayakurhade]

Thank u so much sir.. it was very helpful

[traceyb]

Really helpful. I've subscribed. Thanks very much

[ashwatinairr]

this was a life saver!! Thank you so much

[kalombeandymutambya]

Many thanks for sharing such a great content

[metalplatefiberlasercuttin]

at 0:51, after you inserted a column, did you fill the cells automatically after 1, 2 ? thank you

[ForesterSCS]

Thank you very much for the sharing.. Good Job!

[siyatechworld]

Thanks a Lot, But Sir what if the texts are same for example

ar tools
ar, tools.

then which formula we must use to find whether it is duplicate or not. Pls advice.

[guruprasadbm]

Awesome technique thank I want to delete some duplicate words within the cell. so how to delete duplicate words within the cell. Ex: "Good Good" in in A1 cell there is duplicate so I need only Good, how to delete that duplicate

[thorngphanet]

Hello, what should I do when I don't have edit menu on the top of the bar?

[jacksugden]

Your demonstration does not word in Word 2007 as Insert Tab only allows for:
TABLES
ILLUSTRATIONS
CHARTS
LINKS
TEXT?