❤❤very nice Iive long life

Thanks Guruji for your invaluable Gyan in Excel Drop-down list 🙏❤️❤️❤️

I'm watching your videos for last 7 days! You're one of the best teacher! Huge respect Manoj Ji 🙏🙌❤️

Very Easily and live method is awesome

Thanks... Aapka btane ka tarika best hai

Thanks sir. It's very useful information. 👏👏👏

@ComputerGyanGuruji

3 жыл бұрын

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

@ComputerGyanGuruji

3 жыл бұрын

I will try my best

Excellent Explained Sirji ,🙏

Shabash shabash

Thanks sir for explaining

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

ખૂબ સરસ સાહેબ ....સલામ છે તમને

Bahut badiya

Great job sir

Thanks Sir 🙏

Best

Thank you sir

Thank you

very nice

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

Nice

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

Well taught sir.. problem ...The source currently evaluates to an error. What to do sir

Sir, Please tell me haw can I make a drop list without duplicats in data validation

Dear sir, app acha eexplain kiya ok thanks but one spelling mistake keral Kerala

But sir another site nhi karna ho to select nhi hota hai please own country wala video bano . Ye video bhi nice hai

,,👍🏼👍🏼👍🏼

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

Google sheet me dependant drop down list Kaise Ban sakta hai us per video banaaiye sar

Sir..ye to bs ek cell me drop down lagaya h baki k cell me bhi bar bar lagana padega kya

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.

Guruji MS Excel Download kaise kare ak video banaie

सर हिंदी में डिफेंडेंट शीट की एक वीडियो बना दीजिए सर प्लीज हेल्प मी

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

CREATE FROM SELECTION HOW TO DO FROM OTHER SHEET

Sir State and city divide krne ke liye kaun as function use Kiya hai

@ComputerGyanGuruji

3 жыл бұрын

indirect or data validation

i try but shows reff error in Dependent Drop Down List In Excel,help me.

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🙏🙏🙏🙏🙏🙏🙏

Is there any way to contact you

Sir vba mai dependent drop down kesy banyae sir

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

How to use this dropdown in other row

Ise userform me kaise banaye

The source currently evaluates to an error show kr rha hai

Is video apne Jo search option lagaya o kaise?

I didn't get the state name when I used =direct formula it shows error message#name

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.

@zainulabidinhussainkhan495

2 жыл бұрын

I can help you

@zainulabidinhussainkhan495

2 жыл бұрын

What do you want ?

@atulmehta470

2 жыл бұрын

Thanks for feedback Sir. Issue resolved now.

Still facing error. Please 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.

@ComputerGyanGuruji

6 ай бұрын

yes

Sir मै excel में school सॉफ्टवेयर बना रहा हूँ और मेरे को एक समस्या है कि fee data वाली sheet में मेरा data है और मैं उसे आगे वाली शीट मैं कोई वाउचर बनाया है तो उसमें चाहता हूँ कि जैसे मैं वहाँ कोई class select करू तो मेरे को उसी class का सारा data show करे जैसे कि स्टूडेंट्स का पूरा डाटा ! दूसरी बात की जैसे की फीस स्लीप में और सारा डाटा show करवा लिया है पर मान लो कोई स्टूडेंट्स अपनी फीस कोई किसी माह में तो कोई किसी माह में तो fee slip मैं ऐसा कोनसा फॉर्मूला लगवा की fee sleep में वह ही डेटा show करे जिस माह में fee जमा हुई हैं ? विनती है जवाब जरूर देना

@ComputerGyanGuruji

4 жыл бұрын

bhai aap hamare ye video dekhen shayad aapki problem solve ho jayegi Part-1 kzread.info/dash/bejne/a4FtlM-dhKy-fM4.html part-2 kzread.info/dash/bejne/qH2qzcOMlNTQc8Y.html

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.

@ComputerGyanGuruji

4 жыл бұрын

sure bhai

Sir iss formula ko undo kaisay krain ?

@ComputerGyanGuruji

4 жыл бұрын

jis cell me aapne data validation lagaya hai us cell par jayen or fir se data validation me jayen or clear all kar de

Ham kr rhy hain tho error aata hy.

What to do when there is a space in the Name of Name range?

@pradnyakamble3958

Жыл бұрын

Add "_" between space

Sir, this is only in one row but I want in multiple row. How is it possible?

@ComputerGyanGuruji

3 жыл бұрын

same process, try it

@jiteshraut4599

3 жыл бұрын

yes, i want multiple row. how to do ?

ગુજરાતી નામ drop down list બને

Sir... Bahut aacha hai, but mere se nehi ho raha hai... =Indirect (F2) dene par #REF! aaaa raha hai.. please solve this

@souravneogi5465

Жыл бұрын

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

@ComputerGyanGuruji

4 жыл бұрын

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

@nileshnandanwar04

4 жыл бұрын

@@ComputerGyanGuruji thank you

Please help

Sir nhi ho rha hai

بہت اچھا بھائی ۔۔۔۔۔ کیا ہم آپ سے ایم ایس ورڈ میں فل ایبل فارم پر کوئی بھی سوال کر سکتے ہیں ۔۔۔۔جواب ضرور دینا شکریہ!!!!!!

Indirect function nahi lag raha

Not working

pakistan ka nam dena jaruri tha kya ..koi dusari country nahi mili..Excel Ustad

I like your videos but your English captions are irritating, nothing visible. Dislike it, make videos without captions.

that is not WEST BANGOL , IT would be " WEST-BENGAL "