How to Delete Duplicate Text Entries in Excel : Using Excel

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024

Комментарии • 59

  • @BSBMteam
    @BSBMteam 5 лет назад +8

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

  • @gauravsarraswat6911
    @gauravsarraswat6911 Год назад

    Absoultely useful. Thanks

  • @vikasmohan1665
    @vikasmohan1665 7 месяцев назад

    Very well explained. Thank you so much!!

  • @kporterutley
    @kporterutley 9 лет назад +2

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

  • @venrickace9959
    @venrickace9959 11 месяцев назад

    THAT REALLY HELPED ME, Thank you so much

  • @muallimizzat3580
    @muallimizzat3580 10 месяцев назад

    That saved my time, Thank you!!!

  • @khawajanaseer1801
    @khawajanaseer1801 2 года назад

    Thanks I was searching for it

  • @Sameermc707
    @Sameermc707 3 месяца назад

    Wow really thankyou sir❤❤❤

  • @sushantbharti1982
    @sushantbharti1982 7 лет назад

    I am very thankful for such a helpful presentation

  • @Ahash027
    @Ahash027 Месяц назад

    Saved my time thank u sir

  • @mohamedishky178
    @mohamedishky178 2 месяца назад

    Thank you very much

  • @ahmedsharara5215
    @ahmedsharara5215 5 лет назад

    Thanks for sharing Mr. Ted

  • @hpcredit5614
    @hpcredit5614 Год назад

    THANKS
    😃

  • @Dcrexcinemas-kz7rw
    @Dcrexcinemas-kz7rw Год назад

    Helpful 🎉

  • @kalombeandymutambya4764
    @kalombeandymutambya4764 4 года назад

    Many thanks for sharing such a great content

  • @chhayakurhade879
    @chhayakurhade879 3 года назад

    Thank u so much sir.. it was very helpful

  • @traceyb185
    @traceyb185 8 лет назад

    Really helpful. I've subscribed. Thanks very much

  • @sekharlive
    @sekharlive 3 года назад

    Thank you . Very simple and effective

  • @NaveedKhan-fc1mm
    @NaveedKhan-fc1mm 3 года назад

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

  • @ashwatinairr
    @ashwatinairr 3 года назад

    this was a life saver!! Thank you so much

  • @LezzetYemekTarifleri
    @LezzetYemekTarifleri 2 года назад

    Thanks It is very usefull.

  • @manishvartak3853
    @manishvartak3853 2 месяца назад

    Great sir

  • @zhansayasatybaldy7175
    @zhansayasatybaldy7175 3 года назад

    THAAAANK YOU SO MUCH!

  • @GrindSacrifice
    @GrindSacrifice 8 лет назад

    Awesome thanks ! Def needed this!

  • @sakkachetsomwong1534
    @sakkachetsomwong1534 Год назад

    Thank you very much.

  • @pimpmyvespa_ravenna_official
    @pimpmyvespa_ravenna_official 7 лет назад

    Really useful video!

  • @gauravsadiwal3224
    @gauravsadiwal3224 2 года назад

    Excellent sir My problem is solved

  • @alejandracabrera7699
    @alejandracabrera7699 5 лет назад

    Thanks for the great help!

  • @bookmaster3699
    @bookmaster3699 5 лет назад

    Thanks for sharing this with us!😊

  • @greymarierose
    @greymarierose 3 года назад

    Amazing thanks!

  • @Dcrexcinemas-kz7rw
    @Dcrexcinemas-kz7rw Год назад

    Helpful

  • @ForesterSCS
    @ForesterSCS 8 лет назад

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

  • @krpgamesite6442
    @krpgamesite6442 3 года назад

    Super sir

  • @invisiblechapter
    @invisiblechapter Год назад

    Thanks

  • @moorthirv
    @moorthirv 6 месяцев назад

    THANKS

  • @Blurrybob
    @Blurrybob 6 лет назад

    good job Ted

  • @bryanlesterllosala4615
    @bryanlesterllosala4615 7 лет назад

    Thanks Ted God Bless you...

  • @metalplatefiberlasercuttin9216
    @metalplatefiberlasercuttin9216 4 года назад

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

  • @siyatechworld5323
    @siyatechworld5323 7 лет назад

    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.

  • @Gidelim99
    @Gidelim99 7 лет назад

    Dude, awesome.

  • @thorngphanet3533
    @thorngphanet3533 2 года назад

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

  • @ajayal-hasyim4890
    @ajayal-hasyim4890 8 лет назад

    Thanks Ted

  • @netairoy8913
    @netairoy8913 8 лет назад

    thanks its help me alot ;)

  • @algow2811
    @algow2811 8 лет назад

    i must do subscribe, THX alot

  • @jacksugden8190
    @jacksugden8190 5 лет назад

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

  • @guruprasadbm1987
    @guruprasadbm1987 7 лет назад

    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

  • @amrkhaled3866
    @amrkhaled3866 6 лет назад

    amazing thanks

  • @TanveerAhmad-tu3pm
    @TanveerAhmad-tu3pm 7 лет назад

    thanks sir, nice

  • @shakeboi
    @shakeboi 4 года назад

    Can u do this with numbers?

  • @sachinkv6854
    @sachinkv6854 4 года назад

    How to check for three columns duplicate

  • @sajeevvillody
    @sajeevvillody 6 лет назад

    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
      @alisadenis9929 5 лет назад +1

      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/

  • @bextla3737
    @bextla3737 2 года назад

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

  • @maryjanedelacruz1783
    @maryjanedelacruz1783 4 года назад

    Thank you po 😂

  • @goranstojanov1160
    @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!!

  • @artyafridi
    @artyafridi 5 лет назад

    WELDONE

  • @faizulhaque6951
    @faizulhaque6951 3 года назад

    Thanks

  • @EdmaPacanor
    @EdmaPacanor 5 лет назад

    Thank you!!!