Data Validation and Drop Down List | Auto updating Drop Down List in Excel | Circle Invalid Data
Вставка
- Опубліковано 5 вер 2024
- Learn how to create dependent drop down list in excel using data validation and circle invalid data.
1. Advanced Excel- Data Validation and drop down list
2. Learn how to create smart drop down list in excel suing data validation
3. Learn how to create Data validation auto updating drop down list in excel
4. How to create multiple dependent drop down list in excel
5. Data validation circle invalid data
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#datavalidationlist #datavalidationinexcel#Innozant #dependentlistexcel
Sir You are the best teacher👍Your explanation so great. Never forget your videos.
Thanks Sandeep,I always feel happy whenever I seen your comment.🙏❤️God bless you dear.Happy Diwali
NO NEED TO LOOK FOR ANY OTHER CHANNEL ....THANK YOU SIR
Thanks dear.. Really means a lot to me ❤️👍
This is most Important channel in UA-cam great जै माता दी nice sir ji
Really means a lot to me
DILP sir dil se teach karte hai.awesome teacher awesome person.awesome excel channel innozant
Thanks dear.Keep learning..Keep exploring ❤️
Sir you are very cool and well explained. i really appreciate your teaching method❤❤❤❤
Sir, your teaching method is exceptional
👍👍 best teaching methods sir
Thanks Aftab Alarm Ji🙏❤️ for your lovely comment
Very informative Sir ....😊😊😊
आप पहले गुरु मिले हो इस UA-cam पर जो "हाथ पकड़ कर सही से पेंसिल चलाना" जैसे सीखा रहे हैं। अब beginners के लिए इससे अच्छी शुरुआत क्या होगी। Subscribe तो बनता हैं सर, ❤
Thanks dear...Keep Learning ..God bless You
Very good.. Sir now i can easily understand from your videos..
Thanks Nikhil
This video is also awesome.
sir ji after all data validation video make playlist of it..............
Thanks dear..Apne hi Kaha tha data validation Ka video Lao sir..kaise apko baat na mane phir 👍❤️🙏
Sir you are a good teacher please help me
learn in advanced Google sheet
Kindly start learning Google sheets from our playlist -Googl seehts
Step by step in sequence videos are there..happy learning ❤️
bahot badiaya concept hai sir
🙏🙏🙏
Very useful explanation
Thanks dear❤️
sie very nice teaching plz. reply bundle of thanks
Thank you sir ji, you solved my problem.
Thanks Tarun ji
What a command on Excel mashallah, simply great is the only sentence to describe it.
Thanks dear.Really means a lot to me ..Keep exploring ❤️
I would like admit that I learnt alot watching your UA-cam videos, i sincerely thankyou
Thanks sir ji❤
Thanks sir for nice data validation vedio.
Thanks Tejpal Ji🙏❤️👍
Excellent Sir . Thank You.
beautifully explained 🙏
Thanku sir I try daily practice good night sir
Good Satish.Gn🙏❤️
Sir एक request थी आपसे devolper tab par tutorial बनावो yutube पर एक भी वीडियो नहीं है इस topic पर सारे अधूरे है
Love ur teaching......thanxxxxxx
East and west dilp g best
Sir you are very cool and well explained
- thank you sir
Thanks Mahindra for your valuable feedback ♥️
Thank you sir I await another datavalidation function
Sure dear👍❤️
Sir you are brilliant
Bht behtreen sir
Awesome Training and Examples
Sir good morning sir
Very nice very helpful
Thanks Debal
Nice learning video sir
Thanks Subrata..Happy learning 🙏
Thanks sir your videos are always superb and i leaned a lot. Sir I have a simple list in cell A2 its values are “Yes” and “No”. I want this cell A2 as mandatory; mean it should never be empty. But a problem is there, when I press delete from keyboard, it deletes list element from said cell and no error is displayed. How can I do it without using VBA? If sir are busy and cant reply then i will request sir's student viewers / students to guide me please.
Great
thnx sie playlist bna do topics ki saare alag alag search karna pad rha h ek playlist bna do data validation ki ,,,,
Already Plaistow bana hua hai data validation ka..Playlist me jaake dekhankafen video sabra seprate Playlist hai
Very useful sir. Thank you for your excellent explanation.
Thanks dear👍❤️🙏
You are Super love u
Thanks
Very Nic Very Good
Thnk u
very good sir
My favourite formula is indirect sir proper Dymnic formula
🙏👍❤️Indirect Pura series aane wala hai dear
TQ....SIR
Sometime drop list item I can't visible and drop down icon also missed. What's problem. Solved this problem and inform me
Good
🙏❤️
Excuse me sir i understand this video . but i am very confuse this practical in excel sheet data 👉 Mixed personal & company name list one column ..How can separate company name list another column transfer it. i am requesting sir please make on video ... 🎉✌🙏
Sir eske liye list ko table mei convert krna hoga jisse wo dynamic ho jayega
excellent. thx a lot
sir hmne ctl+t krke bnaani thi aur data validation me duri sheet se list select ki lekin agr hm extra naam jodhte hai to hmaari list show nhi hota hai ,,pls help same sheet pr work krta hai lekin do sheet se kre to nhi krta hai
Sir searchable Drop down list in "simple way" ek video share kijiye !!!!
Ok..noted
Sir, First of all thank you so much for this wonderful videos, but I have seen that you have not replied on any query raised in comments by any user. I also asked a few questions in your videos but have not gotten any response yet.
Thanks Chadha ji,Will always try to respond on queries of students but unable to reach all the queries due to lack of time.
very nice
Thanks
Thanks Sir.
Thanks Tarun ji
sir Question ka solution nai ho raha hai to INDIRECT se krna hai ya only IF se hi krna hai
Sir mera ek issue hai related about vlookup , can I tell you??
Sometime drop down list missing problem solution tell me. What is reason for that.
Hello, I have tried creating the dynamic drop-down from a separate sheet. the procedure you told didn't work then. Please tell us how to do this when getting list from a separate sheet.
Sir advance excel course ke baad aap log job interview ke liye bhejte ho na sir
Yes dear
Sir aapne Jo assignment Diya hai vo if se to dependent drop down list ho gya but sir indirect se samajh mein nhi aaya please reply sir ji😊
Sir data validation me function lagate time uska parameter nhi aata, iska mtlab parameter yaad rakhna padega?🤔
Sir suppose kijiye hamare paas ek Kai saare product ki list hai excel sheet par usme se mujhe ek specific product us list me kitni jagah par aaya hai us ko janna hai aur uski total MRP janni hai
to iske liye kya kare sar help me🙏
Sir how to data auto change date wise using data validation .please explane
Please include searchable drop down list♥️♥️
sure dear...soon
Sir firstly so many thanks to you for your wonderful videos. I have a question, pls help me in this regard.
Suppose I have a situation: I have to assign 'n' number of people to 'n' number of assignments. In a sheet I entered the assignment names in a column. In the next column I made a drop down list of the resource persons. Now I want that, when I attach anyone to some assignment, his name gets deleted from the drop down list, so that no one gets double assignment. Is it possible to make such a drop down list?
pls upload full power bi course
👍❤️
Excellent video sir me bimar ho gya tha mujhhe revision krna h h starting kha se kru please help company bhi nyi join ki h
Oho..ab Sahi Hain..kya ho gya tha..Kahan se chut gya topic Practice..dubara start kijiye
Agar topdwon list main 500 items ho to kase serch kar shakte ha.??
Excel me data validation problem
The list source must be a delimited list; or a reference to single row or Column
Mere me te likh raha hai aur kam nhi kar raha hai please help
Sir mujhe problem nahii huyi indirect samajhne me.. Ku k sabse pehle mene vlookup series hii sikha tha.. Isliye mujhe to pata hai.😂.
Thanku Sir
Thanks Akhil Ji🙏❤️
Can you please share the practice workbook
Link in video description
Sir yur online nd offline classes is avilable....my location at kolkata
Yes..Abhijit..You may join our Live class training as there is no differences in offline or online mode(we are running hybrid classes)
You may visit Innozant website or call/whatsapp us for more details about course and upcoming batches
Sir I Need some help regarding data validation
the list source must be a delimited list, or a reference to single row or column SIR showing this Error
What erro showing on which kind of data
❤️❤️❤️❤️❤️
How to apply the dynamic dropdown list to the
below cells
Dynamic dropdown list videos are rhere i think in tips and tricks playlist
Sir
Aap ne custom data validation mein duplicate entry restrictions batya. Bilkool theek ho gaya.
Lekin hum agar kisi cell mein koi entry ker dete hai aur hum usi colum mein neeche koi doosre duplicate entry type kerte hai to nahi hoti. But upper wali entry ko copy kare aur necche aaker paste kare to duplicate entry ho jati hai. Main try kiya hai ye.
Ok..koi issue aara hai ya aapne kuch new attempt kiya hai?
@@Innozant no bilkool step by step kiya jaise aap ne bataya . Aur koi new attempt nahi . Kaeen baar video pause keke dekh chuka huun aur saath ke saath kiya but kuch samaj nahi aaya ye kyon ho raha hai. Kisi aur newvworkbook mein bhe use kiya but phir bhe paste ho raha hai kripa aap ik baar try kerke dekhe
Kuch aisa ho jaye jisse ki hum item ka ek word type karein or uss se related item show hone lag jaye
Ok..search box Google jaisa chahte hain aap..noted ..will make video for the same
Hi sir,
Multi dependent Dropdown list me "size (eg. 50ml.100ml etc.) kaise add kare according to item....
Jaise red color paint select karne par uska size show kare,(ml ya ltr me..)
Clothes select karne par cloths ka size aaye(meter me)
Plz solve kare.
Sir,
If i have to bring the price automatically in front of item then what formula i will have to use? Because it has 2 dependent drop down list that's why i am confused. Please answer.
Use vlookup or index match, can extract anything from a datasheet
Hi sir,
What is the short cut key to right click on Excel sheet
Shift +F10
hello sir in last example 3 DOJ.it is not showing error if entering a date of sunday or saturday. could you please help me
Share your query?
Sir mujhe Data Validation mein kuch problem aa rahi hai, wo yeah ki agar meri data validation list mein 700 se 800 item hai toh hum kab tak list mein item ko find karte rahenge
Sir ji tab toh aap items ko categorise kar dijiye easy ho jayega find karne mein 🙏
Sir agar source delete krte hai to drop-down me Jo list hota hai delete hojata hh to ky kare ki source to delete ho but drop-down ka me Jo data ho delete nhii ho
Jhabji source data par hi o dependent drropdown rhta hai na
Sir, getting error ,
Mere pass 10-12 headings and their sub headings hai but jab apply kar rhaaa hun to In headings section main sab show Kartar hai but their sub headings section main on first ka hi show kar rhaaa hai and also I had try indirect function
Pls sent us ur communication link so that I can share soft file
Or pls advise
Sir mera y question solve kr dijiye hum ek cell ka total duplicate Nikalte h aise hi pure column ka duplicate ata jaye copy krne pr
Alag cell me formula pass kriye ek Saath range Lene ke bajaye $A$1:A1 isse occurance ek ek krke diluplicate count krta jayega
Sir y prectice sheet download nhi ho rhi
Sir aap ak video iss pe banaye
Jaise ki hamare pas 6 subject hai to >=33 agar 6 subject me hai to pass agar ak subject me >=25 hai to with Grace pass sirf ak subject me aur < 25 wala fail mana jayega aur jis column me fail pass aaye usi me >=33% 3rd division >=51% 2nd division >=71% first division aur jo fail hai wo fail likh ke aaye chahe us ke kitne bhi % mark kyu n ho ye aap video banao sir you tube pe kahi bhi nahi hai aur ye aap hi kar sakte ho aur kisi ke bus me nahi hai
Afesh ji.mye to simple n sted if condition se ho jayega. Dear...acha aap ek kaam kriye sheet share kriye @innozantofficial telegrad id par..kisi vidoe me add kr dunga main solution
@@Innozant ok sir
Bur data list nahi dikhna chahiye uske liye kya kare
If formula not working sir showing error
Office version?
Sir mera ek question hai
A1 me target diya hai xyz c1, c2..... C20 me targat complete iska answer muje b1 me chahiye ek hi colum me
Sir please explain to me
Ek Baar Question phirse explain kijiye ya sheet bhejiye phir formula apply krna jyada aasan rhega dear🙏
Sir , i tried but it's not happening in excel 2019
What prob you are facing there
Hey sir ek query hai apke liye kya ap solve kroge
Ji puchiye🙏
@@Innozant sir WhatsApp kara hai apko plz ek br dekh lena🙏
Hello sir, mujhe excel me kaam kare ke liye ek formula janana hai par wo mil nhi raha kya aap bata denge muje ?
Mam . Tell me the question....i will try .
sir ji make a dependent drop-down list only using by data validation (No any formula) 😕.
Kya baat...sab possible or denge dear...aap Hain hum Hain phir kis baat ki prob..bus aap seekhte seekhte thak mat Jana.🙏❤️
Excel web version video pls
Kindly watch office 365 series for the same
👍
❤️🙏
Clear image nahi aa raha sir
Kya issue
hi meri age aj 28 ho gai h kya fresher ki job mil skti h excel m ya ni plss reply
Paramjeet Sahab..Happy Birthday..Saath hi abhi to career ka initial phase hai dear,Yahan to log 40+ me bhi seekhke apna career stable kar lete hain aur domain change.So don't worry..Have a blooming career ahead
@@Innozant thanx sir ....ek help kardo...agar company wale agar puchege ki apne itne time se job kyo ni ki to mai kya bolunga,,,,,,kyoki maine kabi job ni ki hai pehle
Are kise pata hai Apne job nhi kiya..aur kyu batana Kisi ko ki main to bas khali baitha hoon.humesha Yaad rakhiye job usiki lagti hai jaldi jiske paas pehle se job ho..🙂 .Apni skills badhao aur phir kriye apply job m
@@Innozant thanx sir
Source file does not exist
Please find all excel assignment
In video description main link given..
@@Innozant Thank you for your response. Main Link is very messy. I am not able to locate the exercise file of this video and you already know that direct file link is not working.