Vlookup Duplicate Repeated Values in Excel in Hindi

Поділитися
Вставка
  • Опубліковано 16 лип 2019
  • Many times We have to use Vlookup 2 find Data for repeat values or Duplicate values. Download Practice Files from
    wp.me/p7DKaP-1eX Like a name is repeated many times in your data And you need to find The values against that name with vlookup then This excel tutorial Will help you How to Look up Repeat Data How to Use vlookup To find Repeated Values.
    ** Useful Excel formulas and Functions **
    10 Most Used Formulas MS Excel- • 10 Most Used Formulas ...
    Learn Basic Excel Skills For Beginners- • Learn Basic Excel Skil...
    Learn the Basic of Excel for Beginners - • Learn the Basic of Exc...
    10 Most Used Excel Formula- • 10 Most Used Excel For...
    Learn Vlookup Formula For Beginners in Excel- • Learn Vlookup Formula ...
    5 Excel Questions Asked in Job Interviews- • 5 Excel Questions Aske...
    Create Speedometer Chart In Excel- • Create Speedometer Cha...
    Create Pareto Chart In Excel- • Create Pareto Chart In...
    How to Create Dashboard in Excel- • How to Create Dashboar...
    Excel Interview Questions & Answers- • Excel Interview Questi...
    To watch more videos and download the files visit www.myelesson.org
    To Buy The Full Excel Course visit . www.myelesson.org/product or call 9752003788
    Connect with us on Facebook - / excelmadeasy
    Connect with us on Twitter - / excelmadeasy

КОМЕНТАРІ • 240

  • @abhishek7308
    @abhishek7308 5 років тому +16

    Amazing and outstanding really u r genius in excel becoz u r excel guru. This formula is very helpful for every Accountant so thank's a lot .

    • @GuruJii
      @GuruJii  5 років тому +1

      Thanks Abhishek ji

    • @shahzaibkhan-gw1py
      @shahzaibkhan-gw1py 3 роки тому +1

      @@GuruJii sir when we copy that to other sheet it changes the values

    • @jacobjamari4578
      @jacobjamari4578 2 роки тому +1

      I guess I'm kinda randomly asking but do anyone know of a good place to watch new series online?

    • @kasonchase2121
      @kasonchase2121 2 роки тому

      @Jacob Jamari flixportal xD

    • @jacobjamari4578
      @jacobjamari4578 2 роки тому

      @Kason Chase Thank you, I signed up and it seems to work :D I appreciate it!

  • @amyaditi3641
    @amyaditi3641 3 роки тому

    Thanku sooooooooo much aapne meri sari problem hi solve kardi. Itne sare videoa dekhe but samjh e-lesson se hi aaya. Really indebted to you.

  • @rajarshisarkar6639
    @rajarshisarkar6639 3 роки тому +1

    Respect Sir..You teach with so easy way.Thanks from the bottom of my heart.

  • @vijaybhosale2901
    @vijaybhosale2901 2 роки тому +1

    Thanks for valuable addition in our knowledge, your way of learning and example are most helpful to us. you are true value package of knowledge, learning skill and good humor. Thanks GURU !!

  • @ayushsumbhal3064
    @ayushsumbhal3064 5 років тому

    I love your voice boss.... Its amazing to understand formula with your voice along with slight humour... Thank you so much boss...

  • @ozeesrefrigeration6200
    @ozeesrefrigeration6200 4 роки тому

    Thank you sir from Pakistan. Aapka sikhanay ka tareeka bauhat mazedar hai Masha Allah bauhat saaf zubaan hai apki.

  • @ambreen1692
    @ambreen1692 2 роки тому

    Absolutely awesome! Such an incredible explanation - crisp and clear

  • @diptimayeenayak9464
    @diptimayeenayak9464 2 роки тому

    Thanks sirr.. bohot majedar heyy aap ka teaching style... perfect 🙏

  • @VikasSingh-uz2vb
    @VikasSingh-uz2vb 3 роки тому

    Thank you sir for yourr this information
    Apki iss video se meri kisi or 2 problem ka solution mil gya

  • @gametym8102
    @gametym8102 2 роки тому

    Thanks alot sir, I had a very complicated method earlier now its so Simple... God bless you...

  • @manusencastudent6074
    @manusencastudent6074 5 років тому

    Thank you sir ye meri query thi es tpye ka data mujhe bht jyada problem deta tha solution ke liye thank you so much sir...

  • @debasishmohapatra8606
    @debasishmohapatra8606 3 місяці тому

    Really your teaching style amazing and infomatable..
    Accepted as Guru

  • @sabya1000
    @sabya1000 2 роки тому

    Excellent trick sir... I was looking for this solution ...much needed session

  • @0124akash
    @0124akash 2 роки тому +1

    Thankyou very very much sir
    No words for this vdo sir. Thankyou

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

    Excellent, Excellent and only Excellent .Great Respected Sirs.

  • @ManojYadav-nt2rm
    @ManojYadav-nt2rm Рік тому

    Gurudevji apne mere prob ka solution de diya.Aur apka subcriber bhi hu

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

    Thank you very much sir ji, you are a real guru🙏🙏

  • @sanjeevhdchourey9522
    @sanjeevhdchourey9522 3 роки тому

    Gurudev aap bahut shandar video bante he

  • @sachinkashyap8763
    @sachinkashyap8763 3 роки тому

    Amazing iss chij ke liye maine aggregate formula sikh jo ki mujhe ache se samjh bhi nahi aaya bhi

  • @umershafiq6010
    @umershafiq6010 5 років тому

    #MyElesson
    Sir I'm not telling this that I searched a lot of staff about Excel but I Wana tell you that you are #Amazing. Your Intelligence in Excel is Superb. I think I'm lucky that I have your self as a Montour

  • @gauravnandanwar40
    @gauravnandanwar40 3 роки тому

    Thanks Sir, Jaan bacha liya aapne ye video bana k

  • @thekushwaharahul
    @thekushwaharahul 4 роки тому

    This was awesome sir,
    Sir we put drop-down list insted of typing different name

  • @rahilvhora4901
    @rahilvhora4901 4 роки тому

    Thank you so much sir for making this video it is very helpful.

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

    soooper sir this wt i was searching since a month, tanq sir.

  • @godhan1000
    @godhan1000 5 років тому

    Thanks sir
    सवाल का जवाब देने के लिए ‌

  • @harkeshsharma3264
    @harkeshsharma3264 4 роки тому

    Very nice & so helpful formula, thanks sir

  • @TSAYN.
    @TSAYN. 5 років тому +1

    Hats off to you sir you are just mind-blowing...

  • @sudhiryadav2158
    @sudhiryadav2158 2 роки тому

    Sir your teaching skill superb

  • @akash666692
    @akash666692 3 роки тому

    Nice sir
    Samjhane ka tarika mast h

  • @user-nr8tz4xq5g
    @user-nr8tz4xq5g 3 місяці тому

    You are amazing sir, I gratefull to you

  • @sb-dy1zi
    @sb-dy1zi 5 років тому

    Very easy and nice way of explanation sir

  • @chetansharma6082
    @chetansharma6082 5 років тому +1

    Teaching skills too good

  • @IMRANKHAN-hi9qg
    @IMRANKHAN-hi9qg 9 місяців тому

    Thank you dada❤, big help for you vedio,,❤

  • @mohitgangele5528
    @mohitgangele5528 4 роки тому

    Thanks sir, very useful 👍

  • @AB-ex8ck
    @AB-ex8ck 4 роки тому

    Very simple explanation 👌

  • @deepakvaishy7754
    @deepakvaishy7754 5 років тому +1

    You are great Sir.
    The way you teach is superb.

    • @GuruJii
      @GuruJii  5 років тому

      Thanks Deepak

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

    Superb sir, thank you

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

    Lot Lot Lot of Thanks to You.

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

    Great work. Thanks

  • @RahulKumar-ly6ly
    @RahulKumar-ly6ly 2 роки тому

    Thanks sir very helpful video

  • @nizamkhankhan9705
    @nizamkhankhan9705 4 роки тому

    Amazing sir. Thanks..

  • @adnanaskariaskari2443
    @adnanaskariaskari2443 2 роки тому +1

    Very Nice Sir aap nain bohot achaa skhaaya mujay zroorat thee isee function kee or aap nain meri requirement poori kr dee hain main office main job krtaa hoon or mera kaam aasan ho giaa AAP K LEAY BOHOT BOHOT DUAAIN Naik tmannain.

    • @GuruJii
      @GuruJii  2 роки тому

      THankyou somuch for your blessings
      Thanks. To watch more video please visit www.myelesson.org/

  • @nishantarora7219
    @nishantarora7219 5 років тому

    Waha maza aagya...

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

    Brilliant Sir..!!!

  • @atulshukal4072
    @atulshukal4072 4 роки тому

    Very good Sir shukriya and Thenks

  • @sashak373
    @sashak373 3 роки тому +2

    thanks for your informative video.
    I have a question about the Repeatative/Duplicate entries (Names, Cities, etc..)in XLOOKUP.
    How to deal with the repeapative/duplicate entries in XLOOKUP.
    thanks in advance.

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

    Thank you very much sir

  • @nitinsingh.2107
    @nitinsingh.2107 3 роки тому

    Amazing. Thanks

  • @humanbeingpritam4771
    @humanbeingpritam4771 3 роки тому

    Wow sir mindblowing

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

    Wonderful concept

  • @nikhilkukde6704
    @nikhilkukde6704 5 років тому +1

    Very Nice 👍 👍👌👌

  • @B07477
    @B07477 3 роки тому

    Thanku sir
    Advance excel & sql bhi sikha dijiyega easy way Mai jisse jaldi samjh aaye

  • @worldofsprinkles797
    @worldofsprinkles797 5 років тому

    You are awesome sir

  • @deepushome6122
    @deepushome6122 4 роки тому

    Excellent sir.

  • @krishnapalginare2964
    @krishnapalginare2964 4 роки тому

    Nice teaching sir ji

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

    Superb thanks

  • @manjit.sarania
    @manjit.sarania Рік тому

    Great help to me

  • @RohitGupta-wb3mb
    @RohitGupta-wb3mb 2 роки тому +1

    Hi Sir ... Very good presentations , I need your help for shorting and put the data base Request you to please help me on that

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

    Very good video...

  • @rahulpanwar3097
    @rahulpanwar3097 3 роки тому

    Thanks for this

  • @aayazmuhammedi145
    @aayazmuhammedi145 5 років тому

    Soooper best. 👍

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

    Awesome sir

  • @krishnapalginare2964
    @krishnapalginare2964 4 роки тому

    Sir aapki awaj or hashi bahut hi achhi he

  • @chhavikansal1407
    @chhavikansal1407 5 років тому +8

    thanking you sir.

    • @GuruJii
      @GuruJii  5 років тому +1

      Welcome Chhavi

  • @Anikvikram
    @Anikvikram 3 роки тому

    You are superb

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

    Thank you.........🙏

  • @radhakishangoswami176
    @radhakishangoswami176 2 роки тому +1

    Thank u Sir... the video is very helpful.....

    • @GuruJii
      @GuruJii  2 роки тому

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @arkoentterprise8074
    @arkoentterprise8074 4 роки тому

    thank you so much

  • @rohitacharya2101
    @rohitacharya2101 3 роки тому +1

    Kaash mujhe aisa teacher pehle mil jaata...Abhi race me bahut peeche reh gaya hu mai

    • @GuruJii
      @GuruJii  3 роки тому

      Thanks. But Please don't think you are behind anyone in life You can achieve whatever results you want and whenever you want Just follow your dreams

  • @sagarpathak4804
    @sagarpathak4804 3 роки тому

    Thank you❤

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

    Super 👍 Sir

  • @seniorliaisonofficercoffee2502
    @seniorliaisonofficercoffee2502 2 роки тому +1

    Amazing and excellent Guruji. Namaskar.

    • @GuruJii
      @GuruJii  2 роки тому

      Thanks. To watch more video please visit www.myelesson.org/

  • @patidargaurav
    @patidargaurav 3 роки тому

    salute sir

  • @amleshdubey5985
    @amleshdubey5985 4 роки тому

    Nice sir thanks...I want to learn macro plz suggest

  • @m2kdce
    @m2kdce 3 роки тому

    Hello sir
    I have a question, vlookup always match lookup values in first column of selected array table. But can we search our lookup values in different columns.

  • @nitishpradhan7375
    @nitishpradhan7375 3 роки тому

    We're finding that👍👍

  • @caaman93
    @caaman93 4 роки тому

    Wao amazing...

  • @rupamsingh9787
    @rupamsingh9787 2 роки тому +1

    You are the best Sir!!

    • @GuruJii
      @GuruJii  2 роки тому

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @kumarmaratha2223
    @kumarmaratha2223 4 роки тому +1

    Sir we can put v lookup formula for region too right...

  • @anoopmishra8802
    @anoopmishra8802 3 роки тому

    Thanks sir

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

    Thank you

  • @zeeshanhaider4221
    @zeeshanhaider4221 4 роки тому

    Sir can we use sumif formula in this sheet as well ?? please reply

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

    Superb

  • @payalbhatt2037
    @payalbhatt2037 4 роки тому

    Sometime it is not possible to add helper column in table and need to extract duplicate data and to do total of all duplicate. please advise . i need to finish my one task to do as above mentioned and only allowed to use vlookup formula

  • @sureshkanchan6700
    @sureshkanchan6700 2 роки тому

    Nice thanks

  • @shivanktyagi5332
    @shivanktyagi5332 4 роки тому

    Sir if we need ram sales number in front of ram ,like Aman(C5= E5), Aman (C12=E12), means repeat quantity in just front of repeat coulumb

  • @A_vinaytailor
    @A_vinaytailor 5 років тому

    Nice trick

  • @juggujag6278
    @juggujag6278 3 роки тому

    Sir very easy thought advance filter with drop-down light

  • @maheshswami2064
    @maheshswami2064 5 років тому

    Thank u ji

  • @adbulsami1641
    @adbulsami1641 3 роки тому

    thanks Guru

  • @ManojKumar-cr5ut
    @ManojKumar-cr5ut 2 роки тому

    Very nice

  • @ekdeepmehra2431
    @ekdeepmehra2431 2 роки тому +1

    Thanks sir.👍👍

    • @GuruJii
      @GuruJii  2 роки тому

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @rafatali6058
    @rafatali6058 2 роки тому +1

    Fabulous Sir 👍💤

    • @GuruJii
      @GuruJii  2 роки тому

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @mohdRafiq-np7ls
    @mohdRafiq-np7ls 2 місяці тому

    Great

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

    🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

  • @AltafHussain-fk2gq
    @AltafHussain-fk2gq 2 роки тому

    Awesome

  • @vinayaktirlotkar3500
    @vinayaktirlotkar3500 2 роки тому +1

    Thank u so much sir

    • @GuruJii
      @GuruJii  2 роки тому

      Thank you. To see our latest videos please visit www.myelesson.org/

  • @joydeepghosh9414
    @joydeepghosh9414 2 роки тому +1

    This was asked in my interview

  • @snehaverma9114
    @snehaverma9114 3 роки тому +1

    Sir
    If we need all the names results in one time then how can apply it..?

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

    Thanks