How to Delete Duplicate Text Entries in Excel : Using Excel

[@Sizuedeals]

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

[@BSBMteam]

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

[@Sizuedeals]

Smart, a Thousand likes to this

[@metalplatefiberlasercuttin9216]

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

[@venrickace9959]

THAT REALLY HELPED ME, Thank you so much

[@khawajanaseer1801]

Thanks I was searching for it

[@gauravsarraswat6911]

Absoultely useful. Thanks

[@siyatechworld5323]

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.

[@vikasmohan1665]

Very well explained. Thank you so much!!

[@muallimizzat3580]

That saved my time, Thank you!!!

[@guruprasadbm1987]

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

[@kporterutley]

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

[@jacksugden8190]

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

[@sushantbharti1982]

I am very thankful for such a helpful presentation

[@gauravsadiwal3224]

Excellent sir My problem is solved

[@ahmedsharara5215]

Thanks for sharing Mr. Ted

[@thorngphanet3533]

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

[@Sameermc707]

Wow really thankyou sir❤❤❤

[@kalombeandymutambya4764]

Many thanks for sharing such a great content

[@hpcredit5614]

THANKS
😃

[@mohamedishky178]

Thank you very much

[@LezzetYemekTarifleri]

Thanks It is very usefull.

[@sajeevvillody]

Hi i want to remove duplicate. It remove only one word, i need to remove both same words. Example: (pen, ink, paper, pen, rubber ) .Duplicate finder remove the one pen word, I want to remove both pen words. No more pen word in that column , any formula please.

[@alisadenis9929]

Sajeev Kumar @jesicabella this would work if you have installed excel software, install excel or you can use and online deduplication tool:
www.text-filter.com/tools/remove-duplicate-lines/

[@chhayakurhade879]

Thank u so much sir.. it was very helpful

[@sekharlive]

Thank you . Very simple and effective

[@antonshtessel7626]

What if column has several words and I need to delete only one repeated word? I have apprx 53,000 rows

[@Ahash027]

Saved my time thank u sir

[@NaveedKhan-fc1mm]

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

[@ashwatinairr]

this was a life saver!! Thank you so much

[@bookmaster3699]

Thanks for sharing this with us!😊

[@shakeboi]

Can u do this with numbers?

[@Blurrybob]

good job Ted

[@alejandracabrera7699]

Thanks for the great help!

[@bextla3737]

nice tutorial. l tryed on my text but got error. =IF(B5=B4,''Y'',''N'')

[@traceyb185]

Really helpful. I've subscribed. Thanks very much

[@Dcrexcinemas-kz7rw]

Helpful 🎉

[@GrindSacrifice]

Awesome thanks ! Def needed this!

[@greymarierose]

Amazing thanks!

[@zhansayasatybaldy7175]

THAAAANK YOU SO MUCH!

[@ForesterSCS]

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

[@bryanlesterllosala4615]

Thanks Ted God Bless you...

[@goranstojanov1160]

The + click trick at beggining doesent fill any nu mbers for me whatsoever!!!!! Just stays on the 1 2 and has on side posp soem Quick analyzing and tahst about it it wont auto fill!!

[@manishvartak3853]

Great sir

[@faizulhaque6951]

Thanks

[@sachinkv6854]

How to check for three columns duplicate

[@ajayal-hasyim4890]

Thanks Ted

[@Dcrexcinemas-kz7rw]

Helpful

[@moorthirv]

THANKS

[@krpgamesite6442]

Super sir

[@algow2811]

i must do subscribe, THX alot

[@EdmaPacanor]

Thank you!!!

[@Gidelim99]

Dude, awesome.

[@TanveerAhmad-tu3pm]

thanks sir, nice

[@maryjanedelacruz1783]

Thank you po 😂

[@amrkhaled3866]

amazing thanks

[@netairoy8913]

thanks its help me alot ;)

[@artyafridi]

WELDONE

[@pimpmyvespa_ravenna_official]

Really useful video!

[@himanshubatrasuccessismine6578]

UA-camr always welcome contact me

[@sakkachetsomwong1534]

Thank you very much.

[@invisiblechapter]

Thanks