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

[@uniquemobiletipstricks7714]

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

[@Innozant]

Really means a lot to me

[@khageshprajapati1390]

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

[@Innozant]

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

[@tanvirhussain3074]

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

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

[@techyfighterbyAftab]

👍👍 best teaching methods sir

[@Innozant]

Thanks Aftab Alarm Ji🙏❤️ for your lovely comment

[@velocitypta]

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

[@Innozant]

Thanks dear.Keep learning..Keep exploring ❤️

[@atiqrehman1223]

Sir, your teaching method is exceptional

[@Learn_withkd]

Very informative Sir ....😊😊😊

[@nikhilkumar988]

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

[@Innozant]

Thanks Nikhil

[@sawaimalhi8439]

bahot badiaya concept hai sir

[@Innozant]

🙏🙏🙏

[@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 👍❤️🙏

[@Cagedbutnottamed]

Love ur teaching......thanxxxxxx

[@umeshkumawat3112]

Very useful explanation

[@Innozant]

Thanks dear❤️

[@tarundpatel1]

Thank you sir ji, you solved my problem.

[@Innozant]

Thanks Tarun ji

[@JannatFatima-h7n]

sie very nice teaching plz. reply bundle of thanks

[@madhusudansharma995]

Excellent Sir . Thank You.

[@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 ❤️

[@govindsharma9121]

Sir you are brilliant

[@pubgs5296]

beautifully explained 🙏

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

[@fawadahmed8869]

Bht behtreen sir

[@tejpalsain1507]

Thanks sir for nice data validation vedio.

[@Innozant]

Thanks Tejpal Ji🙏❤️👍

[@satishojha6240]

Thanku sir I try daily practice good night sir

[@Innozant]

Good Satish.Gn🙏❤️

[@rahulkshatriya2786]

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

[@Innozant]

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

[@Excelpro75]

Very useful sir. Thank you for your excellent explanation.

[@Innozant]

Thanks dear👍❤️🙏

[@abbaslokhandwala8445]

Awesome Training and Examples

[@mahendrakumarvala3046]

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

[@Innozant]

Thanks Mahindra for your valuable feedback ♥️

[@debaldey2061]

Very nice very helpful

[@Innozant]

Thanks Debal

[@AiIsfuture-tj4os]

Thanks sir ji❤

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

[@subratasardar4058]

Nice learning video sir

[@Innozant]

Thanks Subrata..Happy learning 🙏

[@pramodbhavsar4488]

Thank you sir I await another datavalidation function

[@Innozant]

Sure dear👍❤️

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

[@Unfiltered_ind]

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

[@intech6998]

Very Nic Very Good

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

[@huzaifahshah3841]

East and west dilp g best

[@kinghundred]

very good sir

[@boomboomtrade_nse_bse3553]

excellent. thx a lot

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

[@anilkumarparmar1784]

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

[@devd3499]

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

[@Innozant]

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

[@bishtlokesh1297]

My favourite formula is indirect sir proper Dymnic formula

[@Innozant]

🙏👍❤️Indirect Pura series aane wala hai dear

[@tarunsehgal5789]

Thanks Sir.

[@Innozant]

Thanks Tarun ji

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

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

[@computerforyou5659]

You are Super love u

[@Innozant]

Thanks

[@tjr1421]

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

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

[@uniquemobiletipstricks7714]

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

[@asrafshah8568]

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

[@vaishnavimarwaha8155]

Can you please share the practice workbook

[@Innozant]

Link in video description

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

[@ukvspk]

Great

[@SantoshSahu-ob2mo]

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

[@vishaldhawale3888]

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

[@Innozant]

Ok..noted

[@ravimaurya7093]

Sir good morning sir

[@ilmco4725]

Sir I Need some help regarding data validation

[@Vedantvlog-gaming]

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

[@rhashmi1]

very nice

[@Innozant]

Thanks

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

[@RMKserve]

Please include searchable drop down list♥️♥️

[@Innozant]

sure dear...soon

[@sadashivkage3133]

TQ....SIR

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

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

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

[@shaileshkumar-qf6bd]

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

[@Vedantvlog-gaming]

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

[@velocitypta]

pls upload full power bi course

[@Innozant]

👍❤️

[@NandKishor-jm1td]

Thnk u

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

[@sachinkumarsachin9687]

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

[@Innozant]

Shift +F10

[@gauravbhatia7987]

Good

[@Innozant]

🙏❤️

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

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

[@gamesworld_all]

Thanku Sir

[@Innozant]

Thanks Akhil Ji🙏❤️

[@vishaldalvi146]

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

[@Innozant]

What prob you are facing there

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

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

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

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

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

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

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

[@mehndidesignbysushmita8304]

Sir y prectice sheet download nhi ho rhi

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

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

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

[@nktdilse2596]

If formula not working sir showing error

[@Innozant]

Office version?

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

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

[@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.🙏❤️

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

[@kavitagujar2820]

Bur data list nahi dikhna chahiye uske liye kya kare

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

[@roshansingh2092]

Clear image nahi aa raha sir

[@Innozant]

Kya issue

[@dqfashionfactory6470]

Excel web version video pls

[@Innozant]

Kindly watch office 365 series for the same

[@nileshchavan742]

👍

[@Innozant]

❤️🙏