How to Find Duplicates in Excel | 3 Ways to Highlight Duplicates in Excel

Поділитися
Вставка
  • Опубліковано 8 вер 2024
  • How to Find Duplicates in Excel | 3 Ways to Highlight Duplicates in Excel
    In this video, I will share you 3 epic ways to highlight duplicate in Excel.
    So watch video till the end & share with your friends & family.
    #exceltricks
    #conditionalformating
    #highlightsduplicate
    ------------------------------------------------------------------------------------------------------------------------------
    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Course Website :bit.ly/skill_c...
    Course Features :
    ✅ सभी Videos सरल हिंदी भाषा में
    ⬇️ Download Video in APP
    ✅ Basic to Advance Courses
    ✅ Practice Files (Yes)
    ✅ PDF Shortcuts
    ✅ Course Completion Certificate
    ✅ Instant Access
    ✅ Watch on Desktop : skillcourse.in/
    ------------------------------------------------------------------------------------------------------------------------------
    Check our latest blogs: learnmoreindia...
    ------------------------------------------------------------------------------------------------------------------------------
    Social media Pages:
    Facebook Page Link: bit.ly/3CvGlBT
    Instagram Page Link: bit.ly/3f9R37u
    Telegram channel: telegram.me/le...
    ------------------------------------------------------------------------------------------------------------------------------
    My Other Channels:
    Real Tutorial: ✅
    / @realtutorial550
    Complete Technology:✅
    / @completetechnology
    Learn more shorts:✅
    / @learnmoreshorts
    Satish Tech (Marathi):✅
    / @satish_tech
    Tally Tutorial:✅
    / @tallytutorial
    Excel Tutorial:✅
    / @excel_tutorial
    Learn More:✅
    / @learn_more
    Curiosity: ✅
    / @curiosity9432
    ------------------------------------------------------------------------------------------------------------------------------
    My UA-cam Gears :
    Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
    Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
    My DSLR Camera Canon 200D: amzn.to/39ciw3E
    My Laptop (Video Editing): amzn.to/2UXQj8h
    Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
    Antivirus: amzn.to/3l3TIgi
    Screen Recording Software: bit.ly/2J39n2j
    Video Editing Software: bit.ly/3nOPlri
    Green screen with Stand: amzn.to/2KAl1Cu

КОМЕНТАРІ • 65

  • @Learn_More_Pro
    @Learn_More_Pro  Рік тому +2

    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Course Website :bit.ly/skill_course
    Course Features :
    ✅ सभी Videos सरल हिंदी भाषा में
    ⬇ Download Video in APP
    ✅ Basic to Advance Courses
    ✅ Practice Files (Yes)
    ✅ PDF Shortcuts
    ✅ Course Completion Certificate
    ✅ Instant Access
    ✅ Watch on Desktop : skillcourse.in/

    • @Priyankabhavya26
      @Priyankabhavya26 Рік тому

      Sir mujhe merge and centre cell fix karna h kaise hoga

  • @ashoksuthar5503
    @ashoksuthar5503 Рік тому +1

    Very nice manner to explain. GURU

  • @swarajdjremix
    @swarajdjremix Рік тому +1

    Nice

  • @prasoontandon1573
    @prasoontandon1573 Рік тому +1

    Great very very helpful video👍

  • @user-ss8eg7yn7g
    @user-ss8eg7yn7g 15 днів тому

    Thanks

  • @swarajdjremix
    @swarajdjremix Рік тому +1

    🎉🎉🎉

  • @aakasheducationalserviceli2170

    Love you sir ❤❤

  • @PRANAY_182
    @PRANAY_182 Рік тому +1

    Super Tricks....🙏🙏

  • @chanderpal7840
    @chanderpal7840 Рік тому

    thank you sir ji your all video hiepful.

  • @8822mishra
    @8822mishra Рік тому

    Awesome sir all doubts are cleared

  • @ApurvaShah
    @ApurvaShah 5 місяців тому

    Dil se thank you❤

  • @arpanraj4404
    @arpanraj4404 Рік тому +1

    very good vido

  • @aakasheducationalserviceli2170

    You are great sir❤❤

  • @dineshpoojary1373
    @dineshpoojary1373 5 місяців тому

    Well presented and explained

  • @DR_Sagar2
    @DR_Sagar2 Рік тому

    Oh wow
    Moz kar di Sir.

  • @rahulnishad6874
    @rahulnishad6874 4 місяці тому

    🎉🎉 brilliant explanation

  • @mihir.mishra
    @mihir.mishra Рік тому +1

    Please make more tutorial videos on LibreOffice.

  • @tt_badmash_9560
    @tt_badmash_9560 8 місяців тому

    Excellent sir

  • @bharti6772
    @bharti6772 8 місяців тому

    Sir Very useful 💻

  • @SmartBoyGamer
    @SmartBoyGamer Рік тому

    You are Great Sir 🎉🎉
    Love from U.P ♥

  • @akramtanoli9751
    @akramtanoli9751 Рік тому

    U r great sir

  • @BankerWriterMosharaf
    @BankerWriterMosharaf 7 місяців тому

    Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence

  • @roshnikalbande1424
    @roshnikalbande1424 Рік тому +1

    Sir can you make a video of offset formula please

  • @tanayaghoshdastidar5286
    @tanayaghoshdastidar5286 Рік тому

    Grt sir 🙏🙏🙏🙏🙏🙏

  • @manshakushwaha519
    @manshakushwaha519 Рік тому

    Thanks sir

  • @pankajkumar-bx7ob
    @pankajkumar-bx7ob Рік тому

    Tarika number 3 acha hai Sir 😎🤣

  • @RameshFunnyreact
    @RameshFunnyreact Рік тому

    Good evening Sir. HTML advance level me hai.🙏🕉️

  • @jatinagravat6810
    @jatinagravat6810 Рік тому +1

    Sir
    Muje Excel me ek se jyada application ka data remove karna hai. Lakin
    Sart yah he ki
    Last me ki huvi application number vali application rahni chahiye.
    ????

  • @mahendrasinghsiddi
    @mahendrasinghsiddi Рік тому +1

    Duplicate numbers Hain bahut sare to unhe remove kese kre means Koi number 2 baar na rahe

  • @51JSR
    @51JSR Рік тому

    Very useful

  • @logingmail9982
    @logingmail9982 Рік тому +1

    Sir ji excel sheet ko kaise separate kare..

  • @monicamarymarion2814
    @monicamarymarion2814 2 місяці тому

    2nd and 3rd way wala hi mujhe interview mei krne diye the

  • @akramtanoli9751
    @akramtanoli9751 Рік тому

    Sir ❤❤❤❤

  • @raginiverma4888
    @raginiverma4888 5 місяців тому

    How to show duplicate number and different colours

  • @Rajkumar23317
    @Rajkumar23317 Рік тому

    Sir kya aap dataman software ke upar koi video bna sakte hai

  • @bhawanamehta3468
    @bhawanamehta3468 Рік тому

    Please make a video for Amazon Sale, how to maintain profit or loss and expenses on the basis of per day sale

  • @digbijayabehera7292
    @digbijayabehera7292 11 місяців тому +1

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

  • @Philowis
    @Philowis 11 місяців тому

    I need some help please 🙏
    How to copy some selected data to new excel file with format.
    Only selected data not entire.

  • @vikashsingh-oi6gq
    @vikashsingh-oi6gq Рік тому

    Hi sir hope you are doing well
    Sir Do you have VBA codeing

  • @sushiljain1820
    @sushiljain1820 Рік тому

    sir please make a video on macro again in full detail

  • @user-gc3sm8zm9s
    @user-gc3sm8zm9s 2 місяці тому

    Sir start sa course Karna ka Liya keya Kara a...plz

  • @ashishverma4597
    @ashishverma4597 Рік тому

    Sir I want many type duplicate highlight diffrent colors. So pls advice.

    • @Biowitharnab
      @Biowitharnab Рік тому

      We can go to the custom option in the conditional formatting dialog box....

  • @Bheshlalgamer
    @Bheshlalgamer Рік тому

    Microsoft acess kya kaam mein aata hai website bna skte hai

  • @Joy.Yog24
    @Joy.Yog24 Рік тому +1

    Hello Sir
    Have a doubt related to drop down list. When I try to move tht coloumn with drop down. Header ke saath drop down list nahi move ho raha hai. Kaunsa option choose Karna hai?

  • @GayanProdip
    @GayanProdip 4 місяці тому

    Sir, jo duplicate nekala hai o agr pura dlt karna hai to kaise karenge

  • @UP15ANUJ
    @UP15ANUJ Рік тому

    Sir coreldraw kasa laran kru
    Uske kost bhut jadya ha

  • @arrow--1233
    @arrow--1233 10 місяців тому

    Sir how to find duplicate data among more than 5 sheets ?

  • @MohdAsif-zi3mm
    @MohdAsif-zi3mm Рік тому

    😮SIR WHAT IF ANALYSIS PER VIDEO BNAYE

  • @DeveshKumar-uv7nk
    @DeveshKumar-uv7nk 6 місяців тому

    Sir agar Excel me same data ki two sheets hai agr dono data sheets ka total amount different aa raha hai or value bhi multiple hai toh dono sheets ka total amount match karne ke lie ye kaise pta kare ki kis value ka amount different hai jisse Karan dono data sheets ka total amount match nhi ho rha plz solve and explain this make a video

  • @imranvibesofficial
    @imranvibesofficial Місяць тому

    EXCEL SHEET ME DATA ENTRY KARTE TIME JO DATA ENTER KIYA HAI USKE BAD WRONG ENTRY SHOW KARTA HAI KIYA PROBLEM HO SAKTI HAI

  • @surajraut8954
    @surajraut8954 5 місяців тому

    एक्सलं मे दो sheet का डेटा कैसें -duplicate value कैसे serch करे

  • @NstiAllahabadfullinformation

    Sir Meri English bahut weak h toh kya mujhe select nhi kiya jayega interview me

  • @aaliyakhanblog2763
    @aaliyakhanblog2763 Рік тому

    Sir data analysis ka kab video ayega

  • @fizastudio9506
    @fizastudio9506 Рік тому

    Dear sir please help
    Jese ki
    Kitchen 1x1.15M 1.00M=1.15m2 likhna ha to Excel Mee kaise likhe sir please help

  • @rsms322
    @rsms322 Рік тому

    sir SAP software classes star kriye

  • @Kullu_Manali_View
    @Kullu_Manali_View Рік тому

    सर् मुजे एसक्सेल में एक ऐसा फॉर्मूला चाहिए था जो मुजे मेरी resistration date के अनुसार मेरे पास जो डाटा है उन सब की age अपने आप हर साल बढ़ती रहे।
    जैसे मेरे पास एक वयक्ति की resistration date 01-01-2023 है और उस समय उसकी age 32 साल है दूसरे कॉलम में और अगली साल 01-01-2024 को उसकी age फॉर्मूले की मददत से age वाले कॉलम में उसकी age 33 साल हो जाए। प्लीज सर् मुजे जल्दी से इस प्रश्न के उत्तर की उम्मीद है आप से।

  • @onehuman6043
    @onehuman6043 Рік тому

    Brother what to do if i hVe 3000 plus data entries

  • @ytgaming162
    @ytgaming162 Рік тому

    Excel मे अगर एक ही column मे Vailid and Invailid है तो Vailid को अलग column मे और Invailid को अलग column मे कैसे करे कौन सी फार्मूला use होगा
    Sir give me answer please

    • @pritykm.8172
      @pritykm.8172 Рік тому

      1 [=1=2 Enter] False( single)
      2 True ( duplicate)
      3
      4
      1
      2
      5
      6
      4

  • @NstiAllahabadfullinformation

    Please reply Sir

  • @user-uz2oh9hy4j
    @user-uz2oh9hy4j 2 місяці тому

    SIR AGAR I CELL MAIN - KY SATH DATA HY TO IS CELL MAIN SA DUPLICATE DATA KISY CHECK KAREN GY. FOR EXAM, 5412-3541-MA3504 2NED CELL MAIN DATA 5454-3541-6415 IS TARAH K DATA SY DUPLICATE FIGHAR 3541 HIGHLIGH KARNA HY

  • @sahibulislam5994
    @sahibulislam5994 Рік тому

    Sir mujhe ak debit and credit ka Excel file banwana he to sir Kiya apka contact number milsakta he

  • @syedwajidali4286
    @syedwajidali4286 Рік тому

    Thanks