Vlookup Duplicate Repeated Values in Excel in Hindi

Поділитися
Вставка
  • Опубліковано 25 гру 2024

КОМЕНТАРІ • 241

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

    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 4 роки тому +1

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

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

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

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

      @Jacob Jamari flixportal xD

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

      @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.

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

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

  • @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/

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

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

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

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

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

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

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

    Excellent, Excellent and only Excellent .Great Respected Sirs.

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

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

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

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

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

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

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

    Fabulous Sir 👍💤

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

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

  • @ManojYadav-nt2rm
    @ManojYadav-nt2rm 2 роки тому

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

  • @IMRANKHAN-hi9qg
    @IMRANKHAN-hi9qg Рік тому

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

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

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

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

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

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

    Gurudev aap bahut shandar video bante he

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

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

    Amazing and excellent Guruji. Namaskar.

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

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

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

  • @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...

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

    You are the best Sir!!

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

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

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

    Teaching skills too good

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

    Thanks Sir, Jaan bacha liya aapne ye video bana k

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

    Very Nice 👍 👍👌👌

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

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

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

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

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

      Thanks Deepak

  • @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/

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

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

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

    Thanks sir.👍👍

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

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

  • @गांवकीयादें-ल7ढ
    @गांवकीयादें-ल7ढ 8 місяців тому

    You are amazing sir, I gratefull to you

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

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

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

    Absolutely awesome! Such an incredible explanation - crisp and clear

  • @vijaybhosale2901
    @vijaybhosale2901 3 роки тому +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 !!

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

    Very easy and nice way of explanation sir

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

    Very simple explanation 👌

  • @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...

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

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

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

    Nice sir
    Samjhane ka tarika mast h

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

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

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

    Brilliant Sir..!!!

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

    Very nice & so helpful formula, thanks sir

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

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

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

    Superb sir, thank you

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

    Sir aapki awaj or hashi bahut hi achhi he

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

    Thanks sir very helpful video

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

    Great work. Thanks

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

    Lot Lot Lot of Thanks to You.

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

    Very good Sir shukriya and Thenks

  • @luisneto2165
    @luisneto2165 5 років тому +2

    Very good. Thank you.

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

      Welcome Luis, the language was not a barrier for you ?

    • @luisneto2165
      @luisneto2165 5 років тому +3

      I have followed your publications (very interesting and I always discover some new trick). The language of Excel is universal so I understand what you are doing / demonstrating. Thank you, again.

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

    thanking you sir.

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

      Welcome Chhavi

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

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

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

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

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

    Thanks sir, very useful 👍

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

    We're finding that👍👍

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

    Nice teaching sir ji

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

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

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

    Wonderful concept

  • @sashak373
    @sashak373 4 роки тому +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.

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

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

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

    Super 👍 Sir

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

    Soooper best. 👍

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

    This was asked in my interview

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

    Thanks for partial knowledge. Why is everything repeating thrice. How to do it when you don't know how many times Aman is repeating.

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

    Helper Column bnana jruri h sir???

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

    Sir lookup value mai input kya sirf column 1 se hi de sakte hai? ya fir dusre column se vi de sakte hai

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

      Kya ye by default sirf column 1 se hi data check karte hai?

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

    Wow sir mindblowing

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

    Sir yehi value ek hi cell mai list mai la sakte hai kya?. Ram is naam dala to agale cell mai useless sare values ki list aajaye.

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

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

    Amazing. Thanks

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

    Very good video...

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

    Amazing sir. Thanks..

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

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

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

    Excellent sir.

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

    You are awesome sir

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

    Superb thanks

  • @manjit.sarania
    @manjit.sarania 2 роки тому

    Great help to me

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

    Is it possible of without helper column

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

    Sir ek problem solve krdo plz 2 sheets hai dono me name same hai some candidates ke but ek sheet me category nhi likhi kya excel dusri sheet me se candidate ko match krke os ki category fill kr sakta hai

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

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

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

    Guys we can simply do this by using power query.....
    Much easier......
    .....😁😁😁

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

    You are superb

  • @mumbo786
    @mumbo786 6 місяців тому

    Excell ke sheet 1 me raw data entry karu or category wise sheet 2 me automatically kaisa entry ho jayga uska video baniya na sir. Or ha sheet 1 me duplicate data bhi rahega as example - same product 2 alag date me sale hua hain.

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

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

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

    hello sir good morning
    Please suggest me how to search by id/number in particular data in which input point is same box as in hospital.

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

    Awesome sir

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

    Waha maza aagya...

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

    Sir is possible to get same result in case look up value is repeating multiple time

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

    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.

  • @SouravKumar-rf2bz
    @SouravKumar-rf2bz 5 років тому +1

    Thanks for this vedio sir

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

      Welcome Saurav

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

    Thanks a lot Sir

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

    Thank you❤

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

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

    Sir very easy thought advance filter with drop-down light

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

    God of Excel

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

    Sir iss formula ko date and value same ho tho kaise use kare pls bataayi ye .....

  • @RaviKumar-sc8ni
    @RaviKumar-sc8ni 3 роки тому

    Sir, how to sum in vlook up if we have the values in Coloumn, can you please help on that?

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

    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

  • @ManishaKumari-we7pq
    @ManishaKumari-we7pq 2 роки тому +1

    Sath mai Hume region bhi chahiye wo bhi horizontaly koi bta skta hai

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

      Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources

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

    Wao amazing...