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.
#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
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 !!
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.
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.
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
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.
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.
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
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 .
Thanks Abhishek ji
@@GuruJii sir when we copy that to other sheet it changes the values
I guess I'm kinda randomly asking but do anyone know of a good place to watch new series online?
@Jacob Jamari flixportal xD
@Kason Chase Thank you, I signed up and it seems to work :D I appreciate it!
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.
Thanks sirr.. bohot majedar heyy aap ka teaching style... perfect 🙏
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.
THankyou somuch for your blessings
Thanks. To watch more video please visit www.myelesson.org/
Thank you sir from Pakistan. Aapka sikhanay ka tareeka bauhat mazedar hai Masha Allah bauhat saaf zubaan hai apki.
Excellent trick sir... I was looking for this solution ...much needed session
Really your teaching style amazing and infomatable..
Accepted as Guru
Excellent, Excellent and only Excellent .Great Respected Sirs.
Thankyou very very much sir
No words for this vdo sir. Thankyou
Respect Sir..You teach with so easy way.Thanks from the bottom of my heart.
Thank you sir for yourr this information
Apki iss video se meri kisi or 2 problem ka solution mil gya
Fabulous Sir 👍💤
Thank you. To see our latest videos please visit www.myelesson.org/
Gurudevji apne mere prob ka solution de diya.Aur apka subcriber bhi hu
Thank you dada❤, big help for you vedio,,❤
soooper sir this wt i was searching since a month, tanq sir.
Thanks alot sir, I had a very complicated method earlier now its so Simple... God bless you...
Gurudev aap bahut shandar video bante he
Kaash mujhe aisa teacher pehle mil jaata...Abhi race me bahut peeche reh gaya hu mai
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
Amazing and excellent Guruji. Namaskar.
Thanks. To watch more video please visit www.myelesson.org/
#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
Instead of vlookup use index and match formula
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...
You are the best Sir!!
Thank you. To see our latest videos please visit www.myelesson.org/
Teaching skills too good
Thanks Sir, Jaan bacha liya aapne ye video bana k
Very Nice 👍 👍👌👌
Amazing iss chij ke liye maine aggregate formula sikh jo ki mujhe ache se samjh bhi nahi aaya bhi
You are great Sir.
The way you teach is superb.
Thanks Deepak
Thank u Sir... the video is very helpful.....
Thank you. To see our latest videos please visit www.myelesson.org/
Thank you very much sir ji, you are a real guru🙏🙏
Thanks sir.👍👍
Thank you. To see our latest videos please visit www.myelesson.org/
You are amazing sir, I gratefull to you
Hats off to you sir you are just mind-blowing...
Thanks
Absolutely awesome! Such an incredible explanation - crisp and clear
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 !!
Very easy and nice way of explanation sir
Very simple explanation 👌
I love your voice boss.... Its amazing to understand formula with your voice along with slight humour... Thank you so much boss...
Thanku sir
Advance excel & sql bhi sikha dijiyega easy way Mai jisse jaldi samjh aaye
Nice sir
Samjhane ka tarika mast h
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤
Brilliant Sir..!!!
Very nice & so helpful formula, thanks sir
Sir we can put v lookup formula for region too right...
Superb sir, thank you
Sir aapki awaj or hashi bahut hi achhi he
Thanks sir very helpful video
Great work. Thanks
Lot Lot Lot of Thanks to You.
Very good Sir shukriya and Thenks
Very good. Thank you.
Welcome Luis, the language was not a barrier for you ?
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.
thanking you sir.
Welcome Chhavi
Thank you so much sir for making this video it is very helpful.
Thanks sir
सवाल का जवाब देने के लिए
Thanks sir, very useful 👍
We're finding that👍👍
Nice teaching sir ji
This was awesome sir,
Sir we put drop-down list insted of typing different name
Wonderful concept
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.
Thank you.........🙏
Super 👍 Sir
Soooper best. 👍
This was asked in my interview
Thanks for partial knowledge. Why is everything repeating thrice. How to do it when you don't know how many times Aman is repeating.
Helper Column bnana jruri h sir???
Sir lookup value mai input kya sirf column 1 se hi de sakte hai? ya fir dusre column se vi de sakte hai
Kya ye by default sirf column 1 se hi data check karte hai?
Wow sir mindblowing
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.
Hi Sir ... Very good presentations , I need your help for shorting and put the data base Request you to please help me on that
Amazing. Thanks
Very good video...
Amazing sir. Thanks..
Nice sir thanks...I want to learn macro plz suggest
Excellent sir.
You are awesome sir
Superb thanks
Great help to me
Is it possible of without helper column
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
Sir
If we need all the names results in one time then how can apply it..?
Guys we can simply do this by using power query.....
Much easier......
.....😁😁😁
You are superb
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.
Sir can we use sumif formula in this sheet as well ?? please reply
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.
Awesome sir
Waha maza aagya...
Sir is possible to get same result in case look up value is repeating multiple time
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.
Thanks for this vedio sir
Welcome Saurav
Thanks a lot Sir
Thank you❤
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
Sir very easy thought advance filter with drop-down light
God of Excel
Sir iss formula ko date and value same ho tho kaise use kare pls bataayi ye .....
Sir, how to sum in vlook up if we have the values in Coloumn, can you please help on that?
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
Sath mai Hume region bhi chahiye wo bhi horizontaly koi bta skta hai
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
Wao amazing...