Data Validation and Drop Down List | Auto updating Drop Down List in Excel | Circle Invalid Data

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

[@sandeepaswal8944]

Sir You are the best teacher👍Your explanation so great. Never forget your videos.

[@Innozant]

Thanks Sandeep,I always feel happy whenever I seen your comment.🙏❤️God bless you dear.Happy Diwali

[@tanvirhussain3074]

Sir you are very cool and well explained. i really appreciate your teaching method❤❤❤❤

[@khageshprajapati1390]

NO NEED TO LOOK FOR ANY OTHER CHANNEL ....THANK YOU SIR

[@Innozant]

Thanks dear.. Really means a lot to me ❤️👍

[@velocitypta]

DILP sir dil se teach karte hai.awesome teacher awesome person.awesome excel channel innozant

[@Innozant]

Thanks dear.Keep learning..Keep exploring ❤️

[@techyfighterbyAftab]

👍👍 best teaching methods sir

[@Innozant]

Thanks Aftab Alarm Ji🙏❤️ for your lovely comment

[@uniquemobiletipstricks7714]

This is most Important channel in KZbin great जै माता दी nice sir ji

[@Innozant]

Really means a lot to me

[@atiqrehman1223]

Sir, your teaching method is exceptional

[@AiIsfuture-tj4os]

Thanks sir ji❤

[@madhusudansharma995]

Excellent Sir . Thank You.

[@Cagedbutnottamed]

Love ur teaching......thanxxxxxx

[@nikhilkumar988]

Very good.. Sir now i can easily understand from your videos..

[@Innozant]

Thanks Nikhil

[@umeshkumawat3112]

Very useful explanation

[@Innozant]

Thanks dear❤️

[@huzaifahshah3841]

East and west dilp g best

[@pubgs5296]

beautifully explained 🙏

[@intech6998]

Very Nic Very Good

[@user-qr8tc2fj4s]

sie very nice teaching plz. reply bundle of thanks

[@rahulkshatriya2786]

आप पहले गुरु मिले हो इस KZbin पर जो "हाथ पकड़ कर सही से पेंसिल चलाना" जैसे सीखा रहे हैं। अब beginners के लिए इससे अच्छी शुरुआत क्या होगी। Subscribe तो बनता हैं सर, ❤

[@Innozant]

Thanks dear...Keep Learning ..God bless You

[@tarundpatel1]

Thank you sir ji, you solved my problem.

[@Innozant]

Thanks Tarun ji

[@sawaimalhi8439]

bahot badiaya concept hai sir

[@Innozant]

🙏🙏🙏

[@govindsharma9121]

Sir you are brilliant

[@fawadahmed8869]

Bht behtreen sir

[@abbaslokhandwala8445]

Awesome Training and Examples

[@uniquemobiletipstricks7714]

Sir एक request थी आपसे devolper tab par tutorial बनावो yutube पर एक भी वीडियो नहीं है इस topic पर सारे अधूरे है

[@msexcelgooglesheet374]

This video is also awesome. sir ji after all data validation video make playlist of it..............

[@Innozant]

Thanks dear..Apne hi Kaha tha data validation Ka video Lao sir..kaise apko baat na mane phir 👍❤️🙏

[@tejpalsain1507]

Thanks sir for nice data validation vedio.

[@Innozant]

Thanks Tejpal Ji🙏❤️👍

[@debaldey2061]

Very nice very helpful

[@Innozant]

Thanks Debal

[@ukvspk]

Great

[@sadashivkage3133]

TQ....SIR

[@rajveersingh-iw3sb]

Sir you are a good teacher please help me learn in advanced Google sheet

[@Innozant]

Kindly start learning Google sheets from our playlist -Googl seehts Step by step in sequence videos are there..happy learning ❤️

[@satishojha6240]

Thanku sir I try daily practice good night sir

[@Innozant]

Good Satish.Gn🙏❤️

[@NandKishor-jm1td]

Thnk u

[@mahendrakumarvala3046]

Sir you are very cool and well explained - thank you sir

[@Innozant]

Thanks Mahindra for your valuable feedback ♥️

[@safeerahmed8252]

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.

[@lawlightplayz4071]

What a command on Excel mashallah, simply great is the only sentence to describe it.

[@Innozant]

Thanks dear.Really means a lot to me ..Keep exploring ❤️

[@lawlightplayz4071]

I would like admit that I learnt alot watching your KZbin videos, i sincerely thankyou

[@ravimaurya7093]

Sir good morning sir

[@boomboomtrade_nse_bse3553]

excellent. thx a lot

[@pareshpatel-me6wj]

Sometime drop list item I can't visible and drop down icon also missed. What's problem. Solved this problem and inform me

[@computerforyou5659]

You are Super love u

[@Innozant]

Thanks

[@pramodbhavsar4488]

Thank you sir I await another datavalidation function

[@Innozant]

Sure dear👍❤️

[@subratasardar4058]

Nice learning video sir

[@Innozant]

Thanks Subrata..Happy learning 🙏

[@kinghundred]

very good sir

[@Excelpro75]

Very useful sir. Thank you for your excellent explanation.

[@Innozant]

Thanks dear👍❤️🙏

[@Bhanot01]

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.

[@pareshpatel-me6wj]

Sometime drop down list missing problem solution tell me. What is reason for that.

[@keshabgarai8866]

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?

[@gauravbhatia7987]

Good

[@Innozant]

🙏❤️

[@tarunsehgal5789]

Thanks Sir.

[@Innozant]

Thanks Tarun ji

[@geetkht84]

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

[@anilkumarparmar1784]

Sir mera ek issue hai related about vlookup , can I tell you??

[@tjr1421]

Sir data validation me function lagate time uska parameter nhi aata, iska mtlab parameter yaad rakhna padega?🤔

[@Unfiltered_ind]

Sir eske liye list ko table mei convert krna hoga jisse wo dynamic ho jayega

[@aru_films]

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🙏

[@avinashbarge9869]

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 ... 🎉✌🙏

[@SantoshSahu-ob2mo]

Sir how to data auto change date wise using data validation .please explane

[@rhashmi1]

very nice

[@Innozant]

Thanks

[@gauravchadha5348]

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.

[@Innozant]

Thanks Chadha ji,Will always try to respond on queries of students but unable to reach all the queries due to lack of time.

[@bishtlokesh1297]

My favourite formula is indirect sir proper Dymnic formula

[@Innozant]

🙏👍❤️Indirect Pura series aane wala hai dear

[@vaishnavimarwaha8155]

Can you please share the practice workbook

[@Innozant]

Link in video description

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@asrafshah8568]

Agar topdwon list main 500 items ho to kase serch kar shakte ha.??

[@gamesworld_all]

Thanku Sir

[@Innozant]

Thanks Akhil Ji🙏❤️

[@ilmco4725]

Sir I Need some help regarding data validation

[@devendergusain8974]

thnx sie playlist bna do topics ki saare alag alag search karna pad rha h ek playlist bna do data validation ki ,,,,

[@Innozant]

Already Plaistow bana hua hai data validation ka..Playlist me jaake dekhankafen video sabra seprate Playlist hai

[@shaileshkumar-qf6bd]

sir Question ka solution nai ho raha hai to INDIRECT se krna hai ya only IF se hi krna hai

[@AiIsfuture-tj4os]

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😊

[@abhiranjan8930]

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

[@shahnawazdaddi1348]

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.

[@Altaf_Alam]

Use vlookup or index match, can extract anything from a datasheet

[@devd3499]

Sir advance excel course ke baad aap log job interview ke liye bhejte ho na sir

[@Innozant]

Yes dear

[@velocitypta]

pls upload full power bi course

[@Innozant]

👍❤️

[@narinderparihar4369]

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

[@Innozant]

Share your query?

[@vishaldhawale3888]

Sir searchable Drop down list in "simple way" ek video share kijiye !!!!

[@Innozant]

Ok..noted

[@abhijitbasu945]

Sir yur online nd offline classes is avilable....my location at kolkata

[@Innozant]

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

[@sachinkumarsachin9687]

Hi sir, What is the short cut key to right click on Excel sheet

[@Innozant]

Shift +F10

[@AlimKhan-bl5sh]

Sir mujhe problem nahii huyi indirect samajhne me.. Ku k sabse pehle mene vlookup series hii sikha tha.. Isliye mujhe to pata hai.😂.

[@devokedevtech2750]

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

[@Innozant]

Oho..ab Sahi Hain..kya ho gya tha..Kahan se chut gya topic Practice..dubara start kijiye

[@realmex2289]

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.

[@alokkashyap6946]

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

[@Altaf_Alam]

Sir ji tab toh aap items ko categorise kar dijiye easy ho jayega find karne mein 🙏

[@SACHiNYADAV-cn1jp]

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

[@RMKserve]

Please include searchable drop down list♥️♥️

[@Innozant]

sure dear...soon

[@saneeshkrishna3818]

How to apply the dynamic dropdown list to the below cells

[@Innozant]

Dynamic dropdown list videos are rhere i think in tips and tricks playlist

[@vipintyagi583]

the list source must be a delimited list, or a reference to single row or column SIR showing this Error

[@Innozant]

What erro showing on which kind of data

[@vishaldalvi146]

Sir , i tried but it's not happening in excel 2019

[@Innozant]

What prob you are facing there

[@ashishkumarjha6731]

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

[@Innozant]

Jhabji source data par hi o dependent drropdown rhta hai na

[@prashanttyagi1156]

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.

[@Innozant]

Ok..koi issue aara hai ya aapne kuch new attempt kiya hai?

[@prashanttyagi1156]

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

[@mehndidesignbysushmita8304]

Sir y prectice sheet download nhi ho rhi

[@nktdilse2596]

If formula not working sir showing error

[@Innozant]

Office version?

[@richaverma9986]

Hello sir, mujhe excel me kaam kare ke liye ek formula janana hai par wo mil nhi raha kya aap bata denge muje ?

[@Altaf_Alam]

Mam . Tell me the question....i will try .

[@mahendrakumarvala3046]

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

[@Innozant]

Ek Baar Question phirse explain kijiye ya sheet bhejiye phir formula apply krna jyada aasan rhega dear🙏

[@monikapawar320]

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

[@Innozant]

Alag cell me formula pass kriye ek Saath range Lene ke bajaye $A$1:A1 isse occurance ek ek krke diluplicate count krta jayega

[@alokkashyap6946]

Kuch aisa ho jaye jisse ki hum item ka ek word type karein or uss se related item show hone lag jaye

[@Innozant]

Ok..search box Google jaisa chahte hain aap..noted ..will make video for the same

[@kavitagujar2820]

Bur data list nahi dikhna chahiye uske liye kya kare

[@nitinrautela5561]

Hey sir ek query hai apke liye kya ap solve kroge

[@Innozant]

Ji puchiye🙏

[@nitinrautela5561]

@@Innozant sir WhatsApp kara hai apko plz ek br dekh lena🙏

[@msexcelgooglesheet374]

sir ji make a dependent drop-down list only using by data validation (No any formula) 😕.

[@Innozant]

Kya baat...sab possible or denge dear...aap Hain hum Hain phir kis baat ki prob..bus aap seekhte seekhte thak mat Jana.🙏❤️

[@nileshchavan742]

👍

[@Innozant]

❤️🙏

[@adeshbhadauriya3636]

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

[@Innozant]

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

[@adeshbhadauriya3636]

@@Innozant ok sir

[@paramjeet975singh3]

hi meri age aj 28 ho gai h kya fresher ki job mil skti h excel m ya ni plss reply

[@Innozant]

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

[@paramjeet975singh3]

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

[@Innozant]

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

[@paramjeet975singh3]

@@Innozant thanx sir

[@kumargaurav5644]

Source file does not exist

[@Innozant]

Please find all excel assignment In video description main link given..

[@kumargaurav5644]

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

[@dqfashionfactory6470]

Excel web version video pls

[@Innozant]

Kindly watch office 365 series for the same

[@roshansingh2092]

Clear image nahi aa raha sir

[@Innozant]

Kya issue

[@mamalik1088]

Excel k Delip Kumar

[@Innozant]

Hahaha... Really means a lot to me dear