आपका बहुत-बहुत धन्यवाद कि आपने इस प्रकार का वीडियो लेकर आते हैं वह भी बहुत साधारण भाषा में, जो व्यक्ति आपके वीडियो को एक बार अच्छी तरह से देख ले तो उसको किसी प्रकार के दिक्कत का सामना ही नहीं करना पड़ेगा और किसी इंस्टिट्यूट में भी नहीं जाना पड़ेगा आपका बहुत-बहुत धन्यवाद सर
सुप्रभातम श्रीमान जी। मैंने आपका "show/hide data" आधारित संबंधित वीडियो देखा जो बहुत ही मजेदार था ।अब मै चाहता हू कि ड्राप-डाउन की सहायता से जिस प्रकार डेटा " Hide /show" होता है ,उसी प्रकार "drop-down "की सहायता से डेटा "Hide"न होकर ,एक साथ बहुत सारे "columns"मे " " formulas"के साथ डेटा चेंज हो जाये ।कृपया ऐसा विडियो भी बनाइये।
Apko nahi malum ki me apke vdo dekhne se pahle sirf excel me likhna and usko font wise ya color karne ke alava kucha bhi nahi ata tha but aj me puri sheet ko bana ke usme kahi trah k formula laga ke mere boss ko impress karta hu jisse unhone khus ho k meri selry bhi badha di hai Me apka bahut bada abhari hu So ap ase hi bariki vdo banate raho and mene jo apko ek thoda sa pucha hai usk bare me jarur batay so tnx again
Sir Deepak Ur way Of teach 2 Good.i like So Much few days Ago i was Join coaching for Class There Is Not wel to learn when friend toald me About U I daily Learn Listen Form ur classes
Its an awesome video. Weldone... Ek cheez puchni hai... Jese ham drop down row me branch code likhen, or next column me jahan names arhe hain, wahan branch numbers, branch manager number, operation manager numbers sab side by side aajae, Just one drop down list me branch code likhne se.. Ye kese bnega.. Plz b btayein..
Thank you for this tutorial. I have been following all your videos and have learned a lot. I would like to know how to how to use dynamic vlookup for Multiple Value which you unfortunately did not show in the video. As per the tutorial do we need to put a Vlookup formula in each cell for it to update the multiple columns? May I please request you to show us how to use Dynamic vlookup for Multiple Value 🙏🙏
Sir apke video bahut hi kam k hai so tnx But is vdo me ek bat aur apne bata di hoti to bahut hi maza aa jata Jese ki apne bataya ki jo no. Next column ya row me fill karte hai to automatic cell ban jata hai is tarah dat bhi automatic aa jay jis din hum usme kuch likhe jis din us sheet ko kholke likhne jay tab vaha date us din ki automatic aa jaye Please i requested ye bhi bata do sir
Hello brother, i do follow ur videos and they helped me very much and am so thankful to u. Would u please show to copy data from one sheet to another sheet using vlookup, which ever formula suits. Plz guide me.
Hello, Deepak ji, good morning. aap ki tarah se bahut badhia xl ki very useful & day today works ke liye fayeda wala video aa raha hai. Thank u very much. is video me sab kuch thik thak hai but one thing - mein ek data banake us sheet ko formula hide kar diya to us ke baad jab mein kuch data entry karta hun to ye table update nahi ho raha hai. uska kuch solution hai kya ?
Nice sir iski jarurat bahut dada thi sir ek or cheez yadi hum invoice mail value dalte jaye to humare pass jo data h usme se sab kuch minus hota jaye ye kese karenge sir plzz arjent h plzz btaye.
Nice sir Sir ek eisi video banaya ki sn style code particular uske bad si 30- 46 s m l xl xxl xxxl yaisaa column wise automatic kaisa banaya sir please esaka sales invoice ka vedio banaki jiyana sir
Deepak ji kya hum apme excel m apna data ko kisi local disk (D,E) m rakh ke kisi dusri file m apna data dekh saktay h jo hamari in file se connect ho or hamara data sahi aata rahe agar hum us m koi bhe entry kare to Please tell us Thanks Yogesh panchal
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Sir helper colum banakar( do cell ko ek me karke name / add) iske bad dynamically update. Vlookup nahi le raha hai value likha raha hai helpe me
Ya countif formula lagane par bhi kam nahi karta hai
जय हिन्द इस video देख देख ही अपनी लाइफ स्टाइल बदल लिया
इसलिए दिल से शुक्रिया ❤❤❤❤
Very Nice, Excellent, Superb, Great teacher and extremely great teaching...Keep it up, Sir. You are the best👍👍👍👍👍👍👍❤❤❤
Ye video 5 minute me bhi pura ho sakta tha, itna lamba krne ki jarorat nahi thi, but acchha sikhne ko mila
sach mein aap ek bohot ache teacher hain....
Sir,Your all Videos are so useful.Thanks.
Sir aap bahut achche sey samjhate ho
Bohat hi lajawab chiz btayi hai, great bhai
Sir i like very much ur videos, i learn so much with the help ur videos
Very useful sir, I will use this in my work
Achchi tarah samaj aa gaya aur achcha laga
Sir ap video bahut acchi ladti hai
😍
please make videos on financial modeling. your teaching method is super cool.
I am.new to.joing this channal.and very instresting learing video
🤗🤗🤗 welcome 😊
Teaching is very nice .l am proud of you
Helpful for my requirement as I needed to display data from two different places at same place.
I like your all views and and videos
You are awesome Dada.Thanks so much for uploading such important excel videos. 👍👍👍👍
Vlookup Full Tutorial Basic to Advanced
ruclips.net/video/V4YgQTFLmyc/видео.html
Thank you sir ,Actually I was looking this kind of Videos for my Daily Report, I got it .
Awesome... All in one video tha.... Thanks
😊
Thanks and very usefull video sir.
आपका बहुत-बहुत धन्यवाद कि आपने इस प्रकार का वीडियो लेकर आते हैं वह भी बहुत साधारण भाषा में,
जो व्यक्ति आपके वीडियो को एक बार अच्छी तरह से देख ले तो उसको किसी प्रकार के दिक्कत का सामना ही नहीं करना पड़ेगा और किसी इंस्टिट्यूट में भी नहीं जाना पड़ेगा आपका बहुत-बहुत धन्यवाद सर
+Smart work in Smart phone 👍
Very2 Thanks to you Sir ..
Thanks for update very useful video...
Sir aapke sare hi video bahut hi ache h our kam ke h ham chahte h ki aap Google sheet pe video banaye
Very nice vedio
Deepak Sir,
बहुत ही बारीक, बड़िया और काम की चीज़ बताई, कृपया ऐसे ही बताते रहे, आपके videos से बहुत फायदा हुआ | : )
+Puneet Vij 👍👍
awsm Dipk ji...sach mein its very useful...Thanks
very very nice video Sir
I LIKE YOUR VIDEO VERY MUCH.
Very helpful sir
very clear explanation , Great
😊🤗
har video me kuch na kuch sikhne ko milta hai
That is very smart form of VLOOKUP. Thanks for publish this video.
Thnks a lot deepak ji very useful video
Your way of teaching is very good. Please make a video on VBA CODE in excel
+amit singh okay...
Good bhaiji
Very interested sir thank you so very
सुप्रभातम श्रीमान जी। मैंने आपका "show/hide data" आधारित संबंधित वीडियो देखा जो बहुत ही मजेदार था ।अब मै चाहता हू कि ड्राप-डाउन की सहायता से जिस प्रकार डेटा " Hide /show" होता है ,उसी प्रकार "drop-down "की सहायता से डेटा "Hide"न होकर ,एक साथ बहुत सारे "columns"मे " " formulas"के साथ डेटा चेंज हो जाये ।कृपया ऐसा विडियो भी बनाइये।
Good bro very useful tricks
Apko nahi malum ki me apke vdo dekhne se pahle sirf excel me likhna and usko font wise ya color karne ke alava kucha bhi nahi ata tha but aj me puri sheet ko bana ke usme kahi trah k formula laga ke mere boss ko impress karta hu jisse unhone khus ho k meri selry bhi badha di hai
Me apka bahut bada abhari hu
So ap ase hi bariki vdo banate raho and mene jo apko ek thoda sa pucha hai usk bare me jarur batay so tnx again
But mere saval ka solution nahi bataya apne
+Pramod Solanki 👍
+Pramod Solanki ok i will publish a video... Regarding ur query
Best technology sir i love ur videos
Very nice video
Sir Deepak Ur way Of teach 2 Good.i like So Much few days Ago i was Join coaching for Class There Is Not wel to learn when friend toald me About U I daily Learn Listen Form ur classes
Sir, You are God for me!
Nice Video Bundle of Thanks Sir
Thank you Deepak jii.
Thanks for uploading such a good informative video
God bless you .. Thank you..
Nice sir ji
Thanks a lots
Thank you so much sir ji
Its an awesome video.
Weldone...
Ek cheez puchni hai...
Jese ham drop down row me branch code likhen, or next column me jahan names arhe hain, wahan branch numbers, branch manager number, operation manager numbers sab side by side aajae,
Just one drop down list me branch code likhne se.. Ye kese bnega..
Plz b btayein..
Super sir
Super sir.....
ThAnk YoU Deepak Sir
very nice brother
Thank u so much sir😊
Thank you for this tutorial. I have been following all your videos and have learned a lot. I would like to know how to how to use dynamic vlookup for Multiple Value which you unfortunately did not show in the video. As per the tutorial do we need to put a Vlookup formula in each cell for it to update the multiple columns?
May I please request you to show us how to use Dynamic vlookup for Multiple Value 🙏🙏
thank you deepak sir
VERY NICE
Super 👌 👌 👌.
Sir apke video bahut hi kam k hai so tnx
But is vdo me ek bat aur apne bata di hoti to bahut hi maza aa jata
Jese ki apne bataya ki jo no. Next column ya row me fill karte hai to automatic cell ban jata hai is tarah dat bhi automatic aa jay jis din hum usme kuch likhe jis din us sheet ko kholke likhne jay tab vaha date us din ki automatic aa jaye
Please i requested ye bhi bata do sir
+Pramod Solanki ok g i will publish video on this topic as soon as possible...
ok and thanks deepak sir
Nice 1 👍
Thank you Brother
wel come to Myanmar
kya bat sir osm video
Good explain everything
Nice video sir
Great Sir g
Thanks sir ji
Superb
Maza aa gaya
Thanku sir
Sir Thank-you so much apki har video unique hoti he thanks again......
Good sir ji
MR TARUN nice video
very weldone deepak G. I learnt too many things here from your video lessons. Please tell me the exact diff b/w vlookup and lookup?
Okay i will publish a video on lookup hlookup and vlookup
Great
😊
good job
Thank you
Hello brother, i do follow ur videos and they helped me very much and am so thankful to u.
Would u please show to copy data from one sheet to another sheet using vlookup, which ever formula suits. Plz guide me.
VERY NIVCE
Hai thanks for this
Also can I get also data like pdf or jpeg attachment automatic from my library or another sheet using vlookup match function
Sir according software demo bataeye sir
Hello Deepak. sumproduct and coutif wala formula se jo ranks hum nikaltay hay kia ye formula dynamic ho sakta hai?
Hi Deepak
Offset formula use kar sakte hey aapka kya suggestion hey.
Offset formula se bhi to hoga yah kam
👍
Hello, Deepak ji, good morning. aap ki tarah se bahut badhia xl ki very useful & day today works ke liye fayeda wala video aa raha hai. Thank u very much. is video me sab kuch thik thak hai but one thing - mein ek data banake us sheet ko formula hide kar diya to us ke baad jab mein kuch data entry karta hun to ye table update nahi ho raha hai. uska kuch solution hai kya ?
+SANTOSH KUMAR ACHARYA okay... I'll check it...
Thanks
Kya month wise sheet pe isko use kar sakte hain
Yaaa sure 👍👍 👍
Nice
Nice sir iski jarurat bahut dada thi sir ek or cheez yadi hum invoice mail value dalte jaye to humare pass jo data h usme se sab kuch minus hota jaye ye kese karenge sir plzz arjent h plzz btaye.
Sure.. I will publish video as soon as possible on this topic
Thnx sir
great
Thanks sir mujhe Grade ka thora promlem hy mark sheet me grade ka videos Dale plz
G
My WhatsApp number 9102813548
My advance excel sikh liya thanks sir
Sir i want to learn inventory purpose videos like products expiration , how to calculate expiry dates before expiration of products
Nice sir
Sir ek eisi video banaya ki sn style code particular uske bad si 30- 46 s m l xl xxl xxxl yaisaa column wise automatic kaisa banaya sir please esaka sales invoice ka vedio banaki jiyana sir
+Dambar Kumar okay g
Hello Sir, aapne full table ka to bta diya bt agr coloum ka data bahut jayda ho to bina count kiye kya hm vlookup se nikl skte h??
To good sir
Sir, I want to ask about Pivot table slicer I am using window 2007 so how will add slicer. Pls help me.
Deepak ji kya hum apme excel m apna data ko kisi local disk (D,E) m rakh ke kisi dusri file m apna data dekh saktay h jo hamari in file se connect ho or hamara data sahi aata rahe agar hum us m koi bhe entry kare to
Please tell us
Thanks
Yogesh panchal
+YOGI LOHAR yas.. We can do it.. I have published a video to link multiple workbooks together.. Please visit our channel playlist