How to count duplicate entry in excel in hindi || count match formula and conditional formatting

इस विडियो मे आप सीखेंगे की बहुत बड़े data मे duplicate को आसानी से कैसे count karen और हाइलाइट करें। count and match formula in advanced excel in hindi, match the duplicate, match count excel using conditional formatting
#msexcel #countmatch #countduplicate
Second channel
/ @computergurujitechnical
more video play list
www.amazon.in/shop/computergyanguruji
MS Excel Videos
• Hindi English Dictiona...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic

Пікірлер: 37

  • @parthopratimdas175
    @parthopratimdas1752 жыл бұрын

    Thank you sir

  • @raizulislam6066
    @raizulislam60663 жыл бұрын

    Very helpful thnx sir

  • @girishrathod5444
    @girishrathod54443 жыл бұрын

    Thanks sirji

  • @harishshinde5025
    @harishshinde50253 жыл бұрын

    Thank u sir i like it,,

  • @JitenderSingh-hg8wl
    @JitenderSingh-hg8wl2 жыл бұрын

    Very nice video. Thanks.

  • @KhuramShahzad-ci1nu
    @KhuramShahzad-ci1nu2 жыл бұрын

    THANKS , IT'S VERY HELPFULL

  • @VijaySharma-do8lj
    @VijaySharma-do8lj Жыл бұрын

    Sir apka video bhut hi acha lga ek chiz smjh nhi aai ki jo match data hai usko filter krke alg sheet par kese save kre

  • @harsinchh4342
    @harsinchh4342 Жыл бұрын

    👍👍👍👍👍 Thank You, Sir.🙏🙏🙏🙏🙏

  • @advisebook2663
    @advisebook26633 жыл бұрын

    Gajab

  • @kk8july
    @kk8july2 ай бұрын

    One thing if i want to count match between two columns as well as within the column so how if that going to be done .. thanks in Adv

  • @noumananjum6060
    @noumananjum60602 жыл бұрын

    Very helpful

  • @sheetalbarapatre6808
    @sheetalbarapatre68083 жыл бұрын

    Thanks for this explanation. I have a little different requirement. Just as you have 2 columns of data. I have only one column with duplicate records. I dont need highlighting the cells but i want the result same as shown in cell E3 for duplicate records. please reply asap

  • @SANCHAYANROY-qs1uh
    @SANCHAYANROY-qs1uh2 жыл бұрын

    THANK U SIR JI....

  • @dwitiroy2700
    @dwitiroy27002 жыл бұрын

    very good

  • @prashant00744
    @prashant007442 жыл бұрын

    1no.

  • @vinayverma9294
    @vinayverma9294 Жыл бұрын

    Sir yadi do sheet me same naam ko match krke avshesh naam kaise alag karenge

  • @zaibgraphics7294
    @zaibgraphics7294 Жыл бұрын

    Sir ager kissi list may only same salary waly names ko show karna hy tho kaisy karain please

  • @sumitawasthi6924
    @sumitawasthi6924 Жыл бұрын

    Sir duplicate naam ko copy karne ka Tarika hai vo or pata chal jae

  • @sushilkushwah331
    @sushilkushwah331 Жыл бұрын

    Multiple column kese match karenge

  • @abcda6537
    @abcda6537Ай бұрын

    How to count duplicate numbers in on column

  • @Sohailreactions
    @Sohailreactions2 жыл бұрын

    Sir agr duplicate value ho aor ham aik cell mein data enter karen aor tamam mein same data chala jaye please

  • @rameshchand3588
    @rameshchand35882 жыл бұрын

    Sir match duplicates Ko ak saath delet kaise kare

  • @learnbooks1604
    @learnbooks16042 жыл бұрын

    Hilide kya cell kese copy karonge?

  • @artfun7907
    @artfun7907 Жыл бұрын

    i have two spared sheets one is called stock with price and another is called calculator in a stock sheet there is 3 columns category and sub category and price that shows in calculator sheet in list form i am not able to get a specific price of category and subcategory wise ex fruit is category and apple is sub category and 100 is price in calculator sheet fruit and apple are showing but how can i get the price of it please help me............ looking to hear from you..

  • @vimalmonga1402
    @vimalmonga14023 жыл бұрын

    Sir if in reconciliation two column same value is there how to find duplicte

  • @cobraking4901
    @cobraking49012 жыл бұрын

    Newmeri digit ho to isme kya karna h

  • @hemantchavan4443
    @hemantchavan44433 жыл бұрын

    Muzhe yee duplicate Data alag karna hai Kese hoga Plz help

  • @hemantchavan4443

    @hemantchavan4443

    3 жыл бұрын

    Plz uska ek video bnau

  • @SurajPrajapati-jl9sm
    @SurajPrajapati-jl9sm3 жыл бұрын

    Sir, haw can make a droplist without duplicats

  • @DeepakSingh-yg2qh

    @DeepakSingh-yg2qh

    11 ай бұрын

    Use remove duplicate then make a dropdown list of unique value.

  • @AwaisZahid
    @AwaisZahid Жыл бұрын

    totally disagreed..... is se asan treeqa hai 2 colum ko slect karin ... conditional formatting > highlights celles rules > duplicate values ki option per click kar k ok kar dain to duplicates cells ajay gy .....

  • @ravibhai6447
    @ravibhai6447 Жыл бұрын

    Duplicate naam h pr uski QTY alg h to naam ek br aaye or jo QTY h uska SUM ho jye aise kaise kre

  • @ComputerGyanGuruji

    @ComputerGyanGuruji

    Жыл бұрын

    Sumif ya sumifs ka use karen

  • @MalikMalik-qt1gt
    @MalikMalik-qt1gt2 жыл бұрын

    F4 key work nhi kr rhi h

  • @neharani9598
    @neharani9598 Жыл бұрын

    Fake video. I have tried but this is not working

  • @saurabhdas2234
    @saurabhdas2234 Жыл бұрын

  • @manjit.sarania
    @manjit.sarania Жыл бұрын

    Thank you sir