Your basics are so clear. Kitna simplify karke explain karte ho. Hats off. Put more videos in excel advanced+machine learnimg+data analysis&management. Many thanks
Guruji ms excel ka toturial for begginers bhi lekar aayiye Jaisa aap ms word ka lekr aye the Mujhe ms word bht ache se smjh aa gya pls excel bhi smjhaye starting se
ish baar dependent drop down list ki ek aishi video banao.. jo puri detail main ho...condition niche di gai hai.. 1. main matlab user ek colom main gya jaha sirf customer ka name likh diya.. ab jab next colom main jaau then ush foam main dependent drop down list main sari value automatic aajaye .. bina list scroll karein.. aur ek badiya ek work book ki dusri sheet main table bani ho thodi smart view type user friendly .. ya ek work book main smart table data bana ho aur dusri work book ki work sheet main foam .. jaha bas ek customer ki drop down list select karo aur jo comman detail hoti h jaise like phone no ,address, reference name ,,uski firm ka name dusre colom automatic aajaye... bina scroll aur select ke... 2. aur jo dusri detail hai at all kisi main bhi underscore ka matter nahi ..ek proffessional dikhna chaiye.. 3. no vba... programming ka name sunte hi dimag main pathar padne lag jate hai.. ishliye no programming.
Thanks for another great video once again... I have a query here; as you have shown dependent list basis table headers, I have a task that I am not able to solve. There are many videos on youtube for this purpose, but the methods are very long and not simple like yours. The task is like I have State names in Column A, City names of these states in Column B, and Villages names of these cities in Column C. It becomes difficult then to make a dependent drop-down list in excel. Can you please help with any solution to this? It is a little bit complicated, I guess. States Cities Villages Rajasthan Jaipur Village-RJ1 Rajasthan Jaipur Village-RJ2 Rajasthan Alwar Village-RA1 Rajasthan Alwar Village-RA2 Haryana Ambala Village-HA1 Haryana Ambala Village-HA2 Haryana Rohtak Village-HR1 Haryana Rohtak Village-HR2
Sir main n ek cell m vlookup 4mula lagaya condition k sath. Ab me chahta hu jaha m vlookup lagaya waha ki condition fullfill ho to formula still rah jaye. Or condition exactly match nhi hoto me ek validation k through us cell ko specific message dena chahta hu.... Matlab sir formula and datavaildation ek sath kaam kare... Kya aisa ho sakta hai. Agar ap k paas koye vdo ho to plz link share kijiye na. Plz🙏🙏🙏🙏🙏🙏🙏
Sir Can you help me to prepare drop down list with column head. Here you have explained with row header. I failing miserably to prepare drop down list by column header. Pl help.
Sir, how can I get a huge amount of data depending on dependent dropdown list? For example, Dropdown 1 : Class ( suppose class V) Dropdown 2 : Sec ( A/B/C) Now I want to get the datas of Class V ( any sec of my choice from dropdown) by clicking on a "Searchbox". Can this be possible? Plz let me know.
Hi, apki videos buhr informative hoti hain. Sir mujy ek problem aa rhi hy, jis tara ap ne countries names ki drop down list banae hy, ye name single hain, agr in names ko double kr den to pir ye without "underscore" accept nai hota. Ap plz ek dependent drop down list banaeay jis mai countries k name multiple hon like " Bangla Desh" or "United kingdom" in mai space hy es leay mai ne for example liky hain,, thanks
Sir मै excel में school सॉफ्टवेयर बना रहा हूँ और मेरे को एक समस्या है कि fee data वाली sheet में मेरा data है और मैं उसे आगे वाली शीट मैं कोई वाउचर बनाया है तो उसमें चाहता हूँ कि जैसे मैं वहाँ कोई class select करू तो मेरे को उसी class का सारा data show करे जैसे कि स्टूडेंट्स का पूरा डाटा ! दूसरी बात की जैसे की फीस स्लीप में और सारा डाटा show करवा लिया है पर मान लो कोई स्टूडेंट्स अपनी फीस कोई किसी माह में तो कोई किसी माह में तो fee slip मैं ऐसा कोनसा फॉर्मूला लगवा की fee sleep में वह ही डेटा show करे जिस माह में fee जमा हुई हैं ? विनती है जवाब जरूर देना
bhai aap hamare ye video dekhen shayad aapki problem solve ho jayegi Part-1 ua-cam.com/video/9M92mdTIXLk/v-deo.html part-2 ua-cam.com/video/vIvkaSdqjCc/v-deo.html
Aap hume wo formula batao ager hum india select kere to India ke sare State aa jaye or next tab main jab koi ek state select kere too us state ke automatically district aa jaye...
Dear Sir cell me hi agar type kare aur A B C D ke hisab se drop down list banti jaye. jaise mai IN type karu to INDIA, INDONESIA ya esse repleted sare name drop down list me dikhne lage aur jo hame chahiye uspar karsan klick karu to usi cell me o name aa jaye es par koi video ho to bataye. please.
Sir... Ek Question tha... Please reply kijiye... KY eaise hi Sakta hai ki hum Google Drive pe kisi Ko PDF send kare... aur wo sirf dekh sake download nahi kar sake.... Agar ha to kaise... Please video banaye... Thank you
bro aap apni pdf file par water mark laga kar protect karke upload karo varna agar ham chahen ki koi download na kar sake to wo uska screen shot le kar pdf convert kar sakta hai or google drive me read only ko option nahi hai
Thanks Guruji for your invaluable Gyan in Excel Drop-down list 🙏❤️❤️❤️
Very Easily and live method is awesome
I'm watching your videos for last 7 days! You're one of the best teacher! Huge respect Manoj Ji 🙏🙌❤️
Thanks... Aapka btane ka tarika best hai
Thanks sir.
It's very useful information.
👏👏👏
Keep watching
Your basics are so clear.
Kitna simplify karke explain karte ho.
Hats off.
Put more videos in excel advanced+machine learnimg+data analysis&management.
Many thanks
I will try my best
Sir your work is appreciable. Please make some easy video on VBA Form designing with printing of different reports with selectively record
❤❤very nice Iive long life
Excellent Explained Sirji ,🙏
ખૂબ સરસ સાહેબ ....સલામ છે તમને
Great job sir
Shabash shabash
Thanks sir for explaining
Bahut badiya
Thanks Sir 🙏
I like your information video. Send me more info. Thank you
Guruji ms excel ka toturial for begginers bhi lekar aayiye
Jaisa aap ms word ka lekr aye the
Mujhe ms word bht ache se smjh aa gya pls excel bhi smjhaye starting se
Thank you
Thank you sir
Best
very nice
Nice
Well taught sir.. problem ...The source currently evaluates to an error. What to do sir
Sir..ye to bs ek cell me drop down lagaya h baki k cell me bhi bar bar lagana padega kya
Sir you have left to teach that if we create the same dependant drop list in row below so it will not work properly in the same manner
सर हिंदी में डिफेंडेंट शीट की एक वीडियो बना दीजिए सर प्लीज हेल्प मी
,,👍🏼👍🏼👍🏼
ish baar dependent drop down list ki ek aishi video banao.. jo puri detail main ho...condition niche di gai hai..
1. main matlab user ek colom main gya jaha sirf customer ka name likh diya..
ab jab next colom main jaau then ush foam main dependent drop down list main sari value automatic aajaye .. bina list scroll karein..
aur ek badiya ek work book ki dusri sheet main table bani ho thodi smart view type user friendly .. ya ek work book main smart table data bana ho aur dusri work book ki work sheet main foam .. jaha bas ek customer ki drop down list select karo aur jo comman detail hoti h jaise like phone no ,address, reference name ,,uski firm ka name dusre colom automatic aajaye... bina scroll aur select ke...
2. aur jo dusri detail hai at all kisi main bhi underscore ka matter nahi ..ek proffessional dikhna chaiye..
3. no vba... programming ka name sunte hi dimag main pathar padne lag jate hai.. ishliye no programming.
Sir, how to i select india and automatically show its state? In my which formula i could do this?
Thanks for another great video once again...
I have a query here; as you have shown dependent list basis table headers, I have a task that I am not able to solve. There are many videos on youtube for this purpose, but the methods are very long and not simple like yours.
The task is like I have State names in Column A, City names of these states in Column B, and Villages names of these cities in Column C. It becomes difficult then to make a dependent drop-down list in excel. Can you please help with any solution to this? It is a little bit complicated, I guess.
States Cities Villages
Rajasthan Jaipur Village-RJ1
Rajasthan Jaipur Village-RJ2
Rajasthan Alwar Village-RA1
Rajasthan Alwar Village-RA2
Haryana Ambala Village-HA1
Haryana Ambala Village-HA2
Haryana Rohtak Village-HR1
Haryana Rohtak Village-HR2
Sir, Please tell me haw can I make a drop list without duplicats in data validation
But sir another site nhi karna ho to select nhi hota hai please own country wala video bano . Ye video bhi nice hai
SIR - INDIRECT FUNCTION NOT WORKING AS INSTRUCTED IN YOUR VIDEO, PLS. HELP, SHOWING RESULT ONLY FOR FIRST COUNTRY
Dear sir, app acha eexplain kiya ok thanks but one spelling mistake keral Kerala
Sir main n ek cell m vlookup 4mula lagaya condition k sath. Ab me chahta hu jaha m vlookup lagaya waha ki condition fullfill ho to formula still rah jaye. Or condition exactly match nhi hoto me ek validation k through us cell ko specific message dena chahta hu....
Matlab sir formula and datavaildation ek sath kaam kare...
Kya aisa ho sakta hai.
Agar ap k paas koye vdo ho to plz link share kijiye na. Plz🙏🙏🙏🙏🙏🙏🙏
i try but shows reff error in Dependent Drop Down List In Excel,help me.
Sir Can you help me to prepare drop down list with column head. Here you have explained with row header. I failing miserably to prepare drop down list by column header. Pl help.
I can help you
What do you want ?
Thanks for feedback Sir. Issue resolved now.
Koi formula ho to bataye, I am using iPad pro iPad excel me drop-down ke liye data validation nahi hai per formula kaam karta hai ..
Sir State and city divide krne ke liye kaun as function use Kiya hai
indirect or data validation
Sir, how can I get a huge amount of data depending on dependent dropdown list?
For example,
Dropdown 1 : Class ( suppose class V)
Dropdown 2 : Sec ( A/B/C)
Now I want to get the datas of Class V ( any sec of my choice from dropdown) by clicking on a "Searchbox".
Can this be possible?
Plz let me know.
yes
Hi, apki videos buhr informative hoti hain. Sir mujy ek problem aa rhi hy, jis tara ap ne countries names ki drop down list banae hy, ye name single hain, agr in names ko double kr den to pir ye without "underscore" accept nai hota. Ap plz ek dependent drop down list banaeay jis mai countries k name multiple hon like " Bangla Desh" or "United kingdom" in mai space hy es leay mai ne for example liky hain,, thanks
بہت اچھا بھائی ۔۔۔۔۔
کیا ہم آپ سے ایم ایس ورڈ میں فل ایبل فارم پر کوئی بھی سوال کر سکتے ہیں ۔۔۔۔جواب ضرور دینا
شکریہ!!!!!!
Is there any way to contact you
Google sheet me dependant drop down list Kaise Ban sakta hai us per video banaaiye sar
I didn't get the state name when I used =direct formula it shows error message#name
What to do when there is a space in the Name of Name range?
Add "_" between space
CREATE FROM SELECTION HOW TO DO FROM OTHER SHEET
Sir मै excel में school सॉफ्टवेयर बना रहा हूँ और मेरे को एक समस्या है कि fee data वाली sheet में मेरा data है और मैं उसे आगे वाली शीट मैं कोई वाउचर बनाया है तो उसमें चाहता हूँ कि जैसे मैं वहाँ कोई class select करू तो मेरे को उसी class का सारा data show करे जैसे कि स्टूडेंट्स का पूरा डाटा !
दूसरी बात की जैसे की फीस स्लीप में और सारा डाटा show करवा लिया है पर मान लो कोई स्टूडेंट्स अपनी फीस कोई किसी माह में तो कोई किसी माह में तो fee slip मैं ऐसा कोनसा फॉर्मूला लगवा की fee sleep में वह ही डेटा show करे जिस माह में fee जमा हुई हैं ? विनती है जवाब जरूर देना
bhai aap hamare ye video dekhen shayad aapki problem solve ho jayegi
Part-1
ua-cam.com/video/9M92mdTIXLk/v-deo.html
part-2
ua-cam.com/video/vIvkaSdqjCc/v-deo.html
The source currently evaluates to an error show kr rha hai
Guruji MS Excel Download kaise kare ak video banaie
Sir, this is only in one row but I want in multiple row. How is it possible?
same process, try it
yes, i want multiple row. how to do ?
How to use this dropdown in other row
Sir vba mai dependent drop down kesy banyae sir
Is video apne Jo search option lagaya o kaise?
Aap hume wo formula batao ager hum india select kere to India ke sare State aa jaye or next tab main jab koi ek state select kere too us state ke automatically district aa jaye...
ગુજરાતી નામ drop down list બને
Ham kr rhy hain tho error aata hy.
Dear Sir cell me hi agar type kare aur A B C D ke hisab se drop down list banti jaye. jaise mai IN type karu to INDIA, INDONESIA ya esse repleted sare name drop down list me dikhne lage aur jo hame chahiye uspar karsan klick karu to usi cell me o name aa jaye es par koi video ho to bataye. please.
sure bhai
Sir... Bahut aacha hai, but mere se nehi ho raha hai... =Indirect (F2) dene par #REF! aaaa raha hai.. please solve this
Same problem . =Indirect(select cell ) dene ke bad "the source currently evaluates to an error" dikha raha hai . Plz help me
Sir... Ek Question tha... Please reply kijiye... KY eaise hi Sakta hai ki hum Google Drive pe kisi Ko PDF send kare... aur wo sirf dekh sake download nahi kar sake.... Agar ha to kaise... Please video banaye... Thank you
bro aap apni pdf file par water mark laga kar protect karke upload karo varna agar ham chahen ki koi download na kar sake to wo uska screen shot le kar pdf convert kar sakta hai or google drive me read only ko option nahi hai
@@ComputerGyanGuruji thank you
Still facing error. Please help.
Sir nhi ho rha hai
Sir iss formula ko undo kaisay krain ?
jis cell me aapne data validation lagaya hai us cell par jayen or fir se data validation me jayen or clear all kar de
Ise userform me kaise banaye
Indirect function nahi lag raha
pakistan ka nam dena jaruri tha kya ..koi dusari country nahi mili..Excel Ustad
Please help
I like your videos but your English captions are irritating, nothing visible. Dislike it, make videos without captions.
Not working
that is not WEST BANGOL , IT would be " WEST-BENGAL "