sir jo recruitment hai plz usi ke bare me btao jo apne link beja hai time period jyda hai or confusion part bhi hai so plz same value ko 2 worksheet me kese find karte hai plz
Hello sir..how are you Sir i am a sales person. I have 6 routs in a week. And visit every each area 48 times in a year. Now i want to get every area sale consolidate in one cell.... Please give guide me..thank you
Thank you deepak ji mai kai dino se pareshan tha na jane kitni sari vidio dekh dali iske liye but finally aapka video dekha. Very helpful for me. So thank you again.
In Excel 2016 and above version this huge brain works reduced. Select Data and convert as a Table and Directly insert Slicer (Hardly it will take 2 minutes) also it will give you more options to choose another look-up filter (e.i Slicer) Anyways Awesome job. 👍 for those who are not yet reached in Excel 2016
Kamal ki video hy bhai. Me is video k lye hht search kia par mujhe shayd pta nahi ta kaise search karna hy. Me ne apky invoices wale 3 parts ki video dekhi wahab bhi sawal pocha tha k kahi aisa nahi ho sakta k me invoice no lekho or dosre sheet se us invoice k against sara data mere invoice me ajay or invoice tayar ho jay. Ab ye kam sekh kr mera kam asan ho gia. Me simply apne invoice me invoice ka no dunga or us invoice k tamam product pehli sheet se copy ho jaingay. I mean thanks alot. Ap ne kam bht asan kar dia. Thank u so much
Thank you very very very very very much. You have no idea how much this video was helpful for me. After 30+ videos I got a solution to my data management because of this video. Kudos to your knowledge on excel. Simply Hats off. :)
Well, sir I would like to tell you that which you have told me under 17:06 minutes, that the same work I took approximate forty five to fifty minutes. Thank you so much for this concept.👌👌👌👌✌✌
THANK YOU VERY MUCH DEEPAKJI. THANKS FOR SUCH A VERY EDUCATIVE VIDEO. I AM NOT ONLY A SUBSCRIBER OF YOUR CHANNEL BUT YOUR FAN ALSO AND I HAVE LEARNT EXCEL EASILY FROM YOU. THANKS.
वेरी वेरी थैंक्स सर मेरी कई दिनों से यह समस्या का समाधान नहीं हो पा रहा था आपके प्रयास से मेरी समस्या का समाधान हो गया है इसके लिए आपको विशेष धन्यवाद वाकई मैं स्ट्रीक के लिए और इस फॉर्मूले के लिए आपका बहुत बहुत आभारी रहूँगा। वाकई आई एम वेरी हैप्पी सर By सब्जेक्ट ज्ञान यूट्यूब चैनल
Apka ye video mera bohot kam me aya..thanks sir..apka ye video ne mera bohot help kiya..mene ye karne ka bohot try kiya tha lekin nahi ho paya..apka ye video dek kar samaj me a geya..thanks..🙏
Sir boht e Zabrdast banya ha man nay is sy boht benefit b liya ha Thanks 😊 ab agr ap is ka koi or soltion dy den Xlookup kay sath to ziyda best ho ga q kay jab ham 40000 tak entries kar rahy han to sheet hang boht hoti ha so agr ap Xlookup kay sath dy den to asan ho jaye ga
This is an amazing method. If u want to know everything about vlookup including multiple match here is my must watch recommendation. ruclips.net/video/vi4olGGjnN4/видео.html
@@RahulGupta-iv5ku yeah u can exploit the array nature of excel instead . This is an amazing method. If u want to know everything about vlookup including multiple match and multiple lookup value here is my must watch recommendation. ruclips.net/video/vi4olGGjnN4/видео.html
Sr Bina vba ke cash book entry ke liye koi vedio bnao Sr ...jisme monthly data or yearly data print.....edit...new work entry ...search .......aap bhot acha or detail se samjate ho sr.....or aasani se samj me aa jata h sr
Hi Mr. Deepak, you have created a very informative video. I have followed the same instructions using the Vlookup function. All things work perfectly except date. It cant copy the date from the data.
Vlookup Full Tutorial Basic to Advanced
ruclips.net/video/V4YgQTFLmyc/видео.html
sir jo recruitment hai plz usi ke bare me btao jo apne link beja hai time period jyda hai or confusion part bhi hai so plz same value ko 2 worksheet me kese find karte hai plz
ruclips.net/video/-W9A9mSKpHQ/видео.html
8200794895 Contact me sir
@@gelotylashtash4665 l
Hello sir..how are you
Sir i am a sales person. I have 6 routs in a week. And visit every each area 48 times in a year. Now i want to get every area sale consolidate in one cell....
Please give guide me..thank you
दीपक मैंने आज आप का वीडियो देखा । सही मायने में आप गुरु हो। Excel पर आपका कमांड जबरदस्त है।
Thank you deepak ji mai kai dino se pareshan tha na jane kitni sari vidio dekh dali iske liye but finally aapka video dekha. Very helpful for me. So thank you again.
Sir ji........mere khvais puri karhi di aaap ne........ Thanks..........🙏🙏🙏
I love this channel............Yes you're ON..........
Great Sir... You are saving my 1/5 times of my office work... Thank You Sir.
This was so helpful man. I wasted time watching other channel videos. This was the most useful. Keep making videos like these, I mean excel.
Thank you sooo much
In Excel 2016 and above version this huge brain works reduced.
Select Data and convert as a Table and Directly insert Slicer (Hardly it will take 2 minutes) also it will give you more options to choose another look-up filter (e.i Slicer)
Anyways Awesome job. 👍 for those who are not yet reached in Excel 2016
Ap se bada koi master nahi you tube par
want to learn office 2019 and office 365
sir abhi tak aap jaisa clear video pure RUclips main kahi nahi hai
Bhai g bhot bhot dhynywaad apka mera sara kaam isi k chkkr me atka pda tha tnks a lot deepak sir
Kamal ki video hy bhai. Me is video k lye hht search kia par mujhe shayd pta nahi ta kaise search karna hy. Me ne apky invoices wale 3 parts ki video dekhi wahab bhi sawal pocha tha k kahi aisa nahi ho sakta k me invoice no lekho or dosre sheet se us invoice k against sara data mere invoice me ajay or invoice tayar ho jay. Ab ye kam sekh kr mera kam asan ho gia. Me simply apne invoice me invoice ka no dunga or us invoice k tamam product pehli sheet se copy ho jaingay.
I mean thanks alot. Ap ne kam bht asan kar dia. Thank u so much
🤗🤗🤗😊😊😊😊😊
Keep learning.. keep supporting 🤗
Great sir,
Kamal kar diya aapne sir
मज़ा आ गया सर ।
Graphic image you title is to the point, and excellent presentation
This was a wonderful explanation - very clear and to the point. Very helpful. God Bless you!
Thank you very very very very very much. You have no idea how much this video was helpful for me. After 30+ videos I got a solution to my data management because of this video. Kudos to your knowledge on excel. Simply Hats off. :)
Very nicely explained.. very good... sir... very useful in my practical work place... Thanks a Lot...
Great. You explained in a very professional way that anyone can understand easily. Thank you
Well, sir I would like to tell you that which you have told me under 17:06 minutes, that the same work I took approximate forty five to fifty minutes. Thank you so much for this concept.👌👌👌👌✌✌
Well done.... its works and I was searching kind of solutions no foreign videos has this solution. Only this indian gave me... it
Thank you thank you thank you...so much sir....!!!! U resolve my problem...!!!!
THANK YOU VERY MUCH DEEPAKJI. THANKS FOR SUCH A VERY EDUCATIVE VIDEO. I AM NOT ONLY A SUBSCRIBER OF YOUR CHANNEL BUT YOUR FAN ALSO AND I HAVE LEARNT EXCEL EASILY FROM YOU. THANKS.
I saw your video on you tube and I taught my computer teacher this trick.
lean more office 2019 and office 365 new formulas and new function
please visit my channel also.
for vlookup
ruclips.net/video/1noGHCUGxUM/видео.html
Channel link
ruclips.net/channel/UCYalru61E3cHHeHqHW3cT_Aabout
Lockdown me ghar per hu to apke video se bhaut kuch sikh gai hu thk u
Thank you so much sir ji I am frm Kashmiri j&k India .... U solved mine big problem ...
Thank you so much sir. You have solved my big problem. I am looking since long time this solution
All Excel Lookup Function: ruclips.net/p/PLl2uwOt1hHQtb5FzyeJezM3bzZAm2B1qr
Duplicate value in vlookup wale comment ka sahi jawab hai . Thanks
thanks Deepak for Excellent explaination -
This can also be used to bring values from adjacent cells at one place of duplicate items & identify the differences between them. Good demo. 👍🏻
Deepak you are doing great job,
Keep it up 👍👍
Thanks you so muchhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
It was my need today..........................From Pakistan Punjab Faisalabad
वेरी वेरी थैंक्स सर
मेरी कई दिनों से यह समस्या का समाधान नहीं हो पा रहा था आपके प्रयास से मेरी समस्या का समाधान हो गया है इसके लिए आपको विशेष धन्यवाद वाकई मैं स्ट्रीक के लिए और इस फॉर्मूले के लिए आपका बहुत बहुत आभारी रहूँगा। वाकई आई एम वेरी हैप्पी सर
By सब्जेक्ट ज्ञान यूट्यूब चैनल
😊
Thanks sir it's very useful for me at workplace
Aap ki sari vdo smjh me ati h
This formula is very useful for Those who doesn't have excel 360
Apka ye video mera bohot kam me aya..thanks sir..apka ye video ne mera bohot help kiya..mene ye karne ka bohot try kiya tha lekin nahi ho paya..apka ye video dek kar samaj me a geya..thanks..🙏
😁👍👍👍
Excellent tutorial Deepak!! You are a genius...
Sir boht e Zabrdast banya ha man nay is sy boht benefit b liya ha Thanks 😊 ab agr ap is ka koi or soltion dy den Xlookup kay sath to ziyda best ho ga q kay jab ham 40000 tak entries kar rahy han to sheet hang boht hoti ha so agr ap Xlookup kay sath dy den to asan ho jaye ga
What an wonderful explanation. Thanks for the work.
You are the best
Thanku sir🤗🤗🤗🤗🤗
Dada Nomoskar. Just Wow.
excellent topic and elaboration on concept
Dear Deepak very useful.
I can't thank you enough. Such an amazing video. This is exactly what I was looking for. Keep up the good work.
Thank you very much for the vedio and good explination with details
Wow. You accomplished exactly what I was looking for. Thank you so much!
This is an amazing method. If u want to know everything about vlookup including multiple match here is my must watch recommendation.
ruclips.net/video/vi4olGGjnN4/видео.html
Very very thanks this video helps me alot
God bless you Deepak. Stay Happy.
You are awesome. I got what I was looking for. Best Technique.
I was struggling in this task.... Thank you so much sir...
🥰
Sir do we have other way if dont want to use & function... Mean vlookup based on two value.. Not using &(helper)
@@RahulGupta-iv5ku yeah u can exploit the array nature of excel instead .
This is an amazing method. If u want to know everything about vlookup including multiple match and multiple lookup value here is my must watch recommendation.
ruclips.net/video/vi4olGGjnN4/видео.html
This was really very helpful. You solved my long time problem in one shot. Thanks a lotttt♥️
Very informative... thank you for sharing
Ek no. Bhai, advance formula
Good job sir
This trick ko mai 1 years se dhund rahath
👍 I was looking for this since long time
I had been looking for this for a long time. Grammatical correct
Tanks you so much sir great job 🙏👍
Sir This is very usefull video thanks for learning for this excel formula
Deepak sir aap gjb ho thanks..... Nice video
Thanks sir for this video and also like all video for extra knowledge
thanks this video helps me a lot. Got my intended result withing in minute
Very Very Thanks venerable sir, I am Proud of you.
Sr Bina vba ke cash book entry ke liye koi vedio bnao Sr ...jisme monthly data or yearly data print.....edit...new work entry ...search .......aap bhot acha or detail se samjate ho sr.....or aasani se samj me aa jata h sr
😊😊🤗🤗👍👍👍 as soon as possible
very educative tutorial .
🤗🤗🤗😊😊
very usefull for my office work thanku so much sir...
Thank you for very useful vedio
Dear sir it's very helpful tips
जबरदस्त सरजी. U r great
Waoo. Thanks GURU JI. i got my answer by this video. THANKS. thats the method i was want to know
😇🤗
Well explained deepak
Bro it's really amazing ...keep it up bro 😍
very nice deepak ji... its very imp.
lean more office 2019 and office 365 new formulas and new function
Very nice presentation
Wonderful explanation keep it up
Thanks sir this video very very helpful 😊for me.
Thank you very much...! It helped me a lot..!
Wonderful Trick sir..
I liked it and also applied on my data
lean more office 2019 and office 365 new formulas and new function
Multiple sheet e data kam karega?
Good Sir aaj mera man bhar gaya sir
VERY VERY INFORMATIVE AND GOT IN NEEDED TIME . THANK YOU, THANK YOU, THANK YOU.
This helped alot... Deepak thanks a ton
Thanked what I was looking for...saved my day
Perfect way of teaching
Excellent explanation, thanks
Thanks for this truly educational video.Jai Hind.
Thanks a lot.. Wonderful and actually solved my seaech what i was exactly looking for👍
That's i was finding sir 🙏🙏🙏
Bhagban me kabse yehi dhond rahathaa🙏🙏😘
Sir aapke jaise behtarin video excel ka video
You are superb bro...👌👌👌👌👌
Its a great job you explain method very very good
Good job Deepak 👏👏👏
Very good Sir Thenks
Wonderful
This technique is very helpful instead of index function
Thank u sir just great idea
bhaut badiya sir
👌 video Deepak
Thanks Mate. It’s very helpful
Good video... advance bhi baki ka batate ho
Dude u r Genius
love you brother
Jai Hind
Awesome video sir thank you so much 🙏
Very Nice Explain Sir 🙏
U r genius
Hi Mr. Deepak, you have created a very informative video. I have followed the same instructions using the Vlookup function. All things work perfectly except date. It cant copy the date from the data.