Data Validation and Drop Down List | Auto updating Drop Down List in Excel | Circle Invalid Data
HTML-код
- Опубликовано: 19 авг 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 RUclips 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
आप पहले गुरु मिले हो इस RUclips पर जो "हाथ पकड़ कर सही से पेंसिल चलाना" जैसे सीखा रहे हैं। अब beginners के लिए इससे अच्छी शुरुआत क्या होगी। Subscribe तो बनता हैं सर, ❤
Thanks dear...Keep Learning ..God bless You
👍👍 best teaching methods sir
Thanks Aftab Alarm Ji🙏❤️ for your lovely comment
Very good.. Sir now i can easily understand from your videos..
Thanks Nikhil
Sir एक request थी आपसे devolper tab par tutorial बनावो yutube पर एक भी वीडियो नहीं है इस topic पर सारे अधूरे है
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 RUclips videos, i sincerely thankyou
sie very nice teaching plz. reply bundle of thanks
Thank you sir ji, you solved my problem.
Thanks Tarun ji
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 ❤️
East and west dilp g best
Love ur teaching......thanxxxxxx
Very useful explanation
Thanks dear❤️
Thanks sir ji❤
beautifully explained 🙏
bahot badiaya concept hai sir
🙏🙏🙏
Excellent Sir . Thank You.
Very Nic Very Good
Thanks sir for nice data validation vedio.
Thanks Tejpal Ji🙏❤️👍
Sir you are very cool and well explained
- thank you sir
Thanks Mahindra for your valuable feedback ♥️
Sir you are brilliant
Thanku sir I try daily practice good night sir
Good Satish.Gn🙏❤️
Awesome Training and Examples
Bht behtreen sir
Sometime drop list item I can't visible and drop down icon also missed. What's problem. Solved this problem and inform me
Very useful sir. Thank you for your excellent explanation.
Thanks dear👍❤️🙏
Thank you sir I await another datavalidation function
Sure dear👍❤️
Sometime drop down list missing problem solution tell me. What is reason for that.
Very nice very helpful
Thanks Debal
Sir good morning sir
Great
TQ....SIR
You are Super love u
Thanks
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.
Thnk u
excellent. thx a lot
very good sir
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 ... 🎉✌🙏
My favourite formula is indirect sir proper Dymnic formula
🙏👍❤️Indirect Pura series aane wala hai dear
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
Thanks Sir.
Thanks Tarun ji
Sir mujhe problem nahii huyi indirect samajhne me.. Ku k sabse pehle mene vlookup series hii sikha tha.. Isliye mujhe to pata hai.😂.
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
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.
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
Good
🙏❤️
Agar topdwon list main 500 items ho to kase serch kar shakte ha.??
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 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🙏
very nice
Thanks
Sir how to data auto change date wise using data validation .please explane
Sir eske liye list ko table mei convert krna hoga jisse wo dynamic ho jayega
Thanku Sir
Thanks Akhil Ji🙏❤️
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.
Sir mera ek issue hai related about vlookup , can I tell you??
Sir data validation me function lagate time uska parameter nhi aata, iska mtlab parameter yaad rakhna padega?🤔
sir Question ka solution nai ho raha hai to INDIRECT se krna hai ya only IF se hi krna hai
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?
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
pls upload full power bi course
👍❤️
Sir advance excel course ke baad aap log job interview ke liye bhejte ho na sir
Yes dear
Sir I Need some help regarding data validation
❤️❤️❤️❤️❤️
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, 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
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
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
How to apply the dynamic dropdown list to the
below cells
Dynamic dropdown list videos are rhere i think in tips and tricks playlist
Can you please share the practice workbook
Link in video description
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 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
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 y prectice sheet download nhi ho rhi
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
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
Hi sir,
What is the short cut key to right click on Excel sheet
Shift +F10
Bur data list nahi dikhna chahiye uske liye kya kare
Sir , i tried but it's not happening in excel 2019
What prob you are facing there
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
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
If formula not working sir showing error
Office version?
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
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.🙏❤️
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🙏
Hey sir ek query hai apke liye kya ap solve kroge
Ji puchiye🙏
@@Innozant sir WhatsApp kara hai apko plz ek br dekh lena🙏
Clear image nahi aa raha sir
Kya issue
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.
Excel web version video pls
Kindly watch office 365 series for the same
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
👍
❤️🙏
Picture not clear
These are old videos