How to Find and Remove Duplicate Entries in Microsoft Excel | Find Duplicate Data in Excel

Поделиться
HTML-код
  • Опубликовано: 20 авг 2024
  • In this video we will learn to Find and Remove Duplicate Entries in Microsoft Excel step by step
    #duplicate_entries_ in_excel
    #find_duplicate_entries
    #find_duplicate
    #removeduplicates
    #remove_duplicate_entries
    #excel_duplicate_data
    #excelfunctions
    #exceltipsandtricks
    #microsoft_excel_tutorial
    #studyspan
    Music: Outside
    Musician: @iksonmusic
    Thank you

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

  • @ak-ux8pr
    @ak-ux8pr 5 месяцев назад +5

    Very very simple and easy to understand formulas gives tension and cause of high blood pressure I have subscribed it, again thanks

  • @KrishanKumar-cq5wk
    @KrishanKumar-cq5wk 5 дней назад +2

    Thankyou ji

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

    You have save my day bro thanks for the content

  • @miyashime730
    @miyashime730 Месяц назад +1

    Thanks very helpful 👌

  • @user-by4xd3vs7l
    @user-by4xd3vs7l 10 месяцев назад +5

    Very easy and helpful. Thank you so much

  • @ManishKumar-pr9ig
    @ManishKumar-pr9ig Месяц назад +1

    Thank you for this information

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

    thanks for short and informational video

  • @SurajSingh-zu4nf
    @SurajSingh-zu4nf 3 месяца назад +1

    Thank you sir for the information

  • @SalimAfsanaVlogs
    @SalimAfsanaVlogs 3 месяца назад +1

    Thanx A Lot For Your Help...It's Working.

  • @sandipgamit4942
    @sandipgamit4942 17 дней назад +1

    Thank you

  • @user-kj2nk2ye7g
    @user-kj2nk2ye7g Месяц назад +1

    Thanks sir

  • @Gugly468
    @Gugly468 4 месяца назад +1

    Thank you Sir, it helped me a lot

  • @MEGHASANGHAVI-s2c
    @MEGHASANGHAVI-s2c 29 дней назад

    Thanks for the knowledge

  • @asifaawan7441
    @asifaawan7441 6 месяцев назад +1

    Thank you so much very well explained keep it up

  • @mayureshkushte102
    @mayureshkushte102 3 месяца назад +1

    Nicely explain

  • @rajanigarg5352
    @rajanigarg5352 21 день назад +1

    Helpful ❤

  • @aashishsingh2198
    @aashishsingh2198 Год назад +1

    Thankyou soo much sir please keep on uploading more tutorials on excel, word and goggle sheets

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

      You are mostly welcome. I have already upload videos on Google Sheets. Kindly check out on my channel

  • @harshraval3827
    @harshraval3827 5 месяцев назад

    Bahot accha. Bahot dhanyavaad. Aapka.

  • @jigmetzasay1331
    @jigmetzasay1331 4 месяца назад +1

    Thank you so much!

  • @user-qf2bx5ft4e
    @user-qf2bx5ft4e 5 месяцев назад

    Thank you so much very well explained keep it up. Honestly, you make my day!

  • @AnilKumar-gl9ny
    @AnilKumar-gl9ny 3 месяца назад +1

    Thanku so much sir

  • @thearvindlal
    @thearvindlal Месяц назад +1

    Thank you Dost

  • @DurgaDevi-qn7fq
    @DurgaDevi-qn7fq 4 месяца назад +1

    Thank you so much sir

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

    So clear and easy thankyou so much sir

  • @vidyadharkumar5701
    @vidyadharkumar5701 5 месяцев назад +1

    Very useful vide😊

  • @rajanverma-wb6nm
    @rajanverma-wb6nm 5 месяцев назад +1

    good information..

  • @ritviknayak5884
    @ritviknayak5884 3 месяца назад +1

    Thank you so much

  • @ibrahimshah8895
    @ibrahimshah8895 Месяц назад +1

    Dhanyawad

  • @zainsk786
    @zainsk786 Месяц назад +1

    Thankyou 🤗

  • @sandhyadwivedi3317
    @sandhyadwivedi3317 Месяц назад +1

    Tqs sir

  • @vidyadharkumar5701
    @vidyadharkumar5701 5 месяцев назад +1

    Thanks again

  • @GAYANPUHOR
    @GAYANPUHOR 3 месяца назад +1

    Thank you 🙏🙏

  • @nimishakumari4863
    @nimishakumari4863 Год назад +1

    Tq you it helps me a lot

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

      You are mostly welcome. Stay tuned for latest videos

  • @orbi_the_boss4828
    @orbi_the_boss4828 3 месяца назад +1

    Thnx vai...

  • @anujmishra4374
    @anujmishra4374 Год назад +1

    Thanks a lot bro , perfect video for my issues

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

      You are mostly welcome. Stay tuned for latest videos

  • @nirmalrajwade1347
    @nirmalrajwade1347 Год назад +1

    Thank you bro useful this video

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

      You are mostly welcome. Stay tuned for latest videos

  • @LALITKUMAR-os5nu
    @LALITKUMAR-os5nu 5 месяцев назад

    It was really nice work

  • @ComputerServiceBinary
    @ComputerServiceBinary Год назад +1

    thanks for good video

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

      You are mostly welcome. Stay tuned for latest videos

  • @nikitagupta7876
    @nikitagupta7876 Год назад +1

    Thank you. I have subscribed your channel you help.

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

      You are mostly welcome. Stay tuned for latest videos

  • @sabrirang8096
    @sabrirang8096 20 дней назад +1

    Nice

  • @EducationofMahmud
    @EducationofMahmud 7 месяцев назад +1

    Microsoft Excel 2010 and the Remove Duplicates
    Hindi

  • @shreepatel5250
    @shreepatel5250 4 месяца назад +1

    thank you

  • @sweetigupta8420
    @sweetigupta8420 8 месяцев назад +3

    How to remove any formula from filter data

  • @user-cw6qy5jn2e
    @user-cw6qy5jn2e 9 месяцев назад

    Excellent 👍

  • @janardhandas7388
    @janardhandas7388 Год назад +1

    very helpful video

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

      Thank you so much. Stay tuned for latest videos

  • @malabikabasu5310
    @malabikabasu5310 8 месяцев назад

    Thank you! You literally saved my life!🎉

  • @BalbirSingh-sk9jz
    @BalbirSingh-sk9jz 3 месяца назад +1

    Thanks

  • @manojkumarvemula1397
    @manojkumarvemula1397 9 месяцев назад

    Tq u helped me alot

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

    Thanks bro. I knew it but forgot after i didnt use for long time

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

    really its easy and understandable

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

    Please make a video on this. I have a sheet which contains data in rows and columns. And there are 4 blank rows after every data row and I want to fill the 1st blank row with the data of sheet 2 and 2nd row with sheet 3 and 3rd row with sheet 4 and 4th row with sheet 5 please make a video it's getting very difficult

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

    Thank you sir

  • @user-uy6me5lc8k
    @user-uy6me5lc8k Месяц назад +1

    Jiyo!

  • @d.kumardbg3537
    @d.kumardbg3537 10 месяцев назад

    very nice sir

  • @user-cq2mw5vk3i
    @user-cq2mw5vk3i 9 месяцев назад

    Big love for this person.. very informative ❤ love you broh

  • @diptidls1
    @diptidls1 5 месяцев назад

    Thanks from vedanggam

  • @HamdanYouTuber
    @HamdanYouTuber Год назад +1

    Useful, thank you.

    • @StudySpan
      @StudySpan  Год назад +1

      You are mostly welcome. Stay tuned for latest videos

  • @surajSingh-yi9me
    @surajSingh-yi9me Год назад +1

    Thanks bro..

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

      You are mostly welcome. Stay tuned for latest videos

  • @harishdupaguntla4917
    @harishdupaguntla4917 8 месяцев назад

    Thank you Bro

  • @MilitaryAcademy
    @MilitaryAcademy Месяц назад +1

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

    I export data from tally which has formatting of dr and cr entries...is there any formula which can separate dr entries one side and cr entries one side

  • @arrow--1233
    @arrow--1233 9 месяцев назад +1

    How to find out duplicate entries in different sheet

  • @somuRamu
    @somuRamu Год назад +1

    Super sir

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

      Thank you so much. Stay tuned for latest videos

  • @user-fr3vm1ex4c
    @user-fr3vm1ex4c 5 месяцев назад

    Thnk u so much

  • @AhmadAhmad-tl9nt
    @AhmadAhmad-tl9nt 13 дней назад +1

    👌👌

  • @zenithdhaka7406
    @zenithdhaka7406 5 месяцев назад

    nice

  • @Bell4Fun
    @Bell4Fun 28 дней назад +1

    want to clear cell value but not cell

  • @ankitsrivastavaMV
    @ankitsrivastavaMV Год назад +1

    good job

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

      Thank you so much. Stay tuned for latest videos

  • @indugulia6461
    @indugulia6461 Год назад +1

    Thankyou

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

      You are mostly welcome. Stay tuned for latest videos

  • @Sujoybarmonujjal
    @Sujoybarmonujjal Год назад +1

    Love this

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

      Thank you so much. Stay tuned for latest videos

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

    Thank you 😊

  • @sajjadhosen2366
    @sajjadhosen2366 9 месяцев назад

    Thank u❤

  • @user-jx8mt6cp2d
    @user-jx8mt6cp2d 11 месяцев назад

    thanks bro

  • @anurag6311
    @anurag6311 День назад

    Bhaiya ye kewal ek cell per apply ho raha hai, agar hume alag alag cell me same value hai aur ushe remove karna hai toh kaise hoga

  • @traptigupta4894
    @traptigupta4894 Год назад +1

    Useful video....Can you please share this excel file

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

      Thank you so much. Stay tuned for latest videos

  • @syedshadan3992
    @syedshadan3992 7 месяцев назад +2

    Actually data another sheet se copy krke file bnani ho mtlb copy or paste krna he but duplicate entry na ho or ye format proper work nhi kr rha bhut sare duplicate ko highlights nhi bta rha so what i do?

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

    There is a limiatiom in it as we need one entry should remain the duplicate of that value should be deleted....is there any method? Suggestions are welcome

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

    Tha kyou

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

    brother how you zoom in and out the tool bar this is the option in excel or in video editor, then tell me editor name

  • @nkbala
    @nkbala Год назад +1

    Show something that deletes the original along with the duplicate

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

    I have 20 cr Data which is present in different sheets. how i can check/ remove duplicate entry.

  • @pankajchouhan6133
    @pankajchouhan6133 9 месяцев назад

    Mera excel sheet automatic duplicate value ko show kar raha hai jo mai nahi chahta, koi upay bataiye, qki mai salary sheet bana raha hu to kai logo ka same hai to colored aa jaa raha hai or print me bhi to mai ye nahi chahta .

  • @activemohsin786
    @activemohsin786 4 месяца назад

    Meri problem alg hai kya aap thik kar skte hai

  • @pradhan_majhi
    @pradhan_majhi 10 месяцев назад +2

    Mene same kiya steop by step lekin mera likh raha hai No duplicate values found but jab ki duplicate value highlight hua

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

    Sir example: ki hamare pass 100 students ka ya employee ka data hai use ke ander se no ,name , address, and Mobile number ye data fill Kiya huwa hai ,lekin kuch students ka mobile number nahi hai to 1 click mai muje un students ka data delete kerna hai jis ka mobile number nahi hai to kaise kare ge please explain next video

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

      Mobile nmbr heading pr Filter lgana or filter me blank ka option ayega blank pr click krna uske baad row nmber jaise 1,2,3,4 sheet pe likhe hote h waha se blank rows ko delete krna or filter hata k check krna apke bina mobile wale students delete ho gye.

  • @devrajs86
    @devrajs86 Год назад +1

    Can you please share excel file

  • @annpurnadevi99
    @annpurnadevi99 5 месяцев назад

    Sir duplicate highlighted hatai kaise

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

    Unka zone alag he to galat dublicate calue le liye ge

  • @sachinagavane9260
    @sachinagavane9260 8 месяцев назад

    Sirf Value delete karana he.. ye pura Cell Ko delete kara raha he...????

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

    Home tab nahi aa raha hai

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

    Dublicate data to nahi lag rha he

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

    Nahi ho raha he sir

  • @ayushmandas4557
    @ayushmandas4557 6 месяцев назад +1

    This is data loss!

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

    Nahi huwa bhai mera

  • @harishtube77
    @harishtube77 5 месяцев назад

    Galat bataye aapne, formula chahiye tha

  • @maddo6465
    @maddo6465 2 месяца назад +1

    Thankyou 😊

  • @jayantakumarmohanty6037
    @jayantakumarmohanty6037 4 месяца назад +1

    Thanks sir

  • @rakeshsasmal3125
    @rakeshsasmal3125 Месяц назад +1

    Thank you

  • @user-gy4th5ff3x
    @user-gy4th5ff3x 4 месяца назад +1

    Thanks

  • @RiteshYadav-pq1wo
    @RiteshYadav-pq1wo 5 месяцев назад

    Nice