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

Подписаться 149 тыс.

Просмотров 113 тыс.

50% 1

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.com/file/d/1_XSp...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#datavalidationlist #datavalidationinexcel#Innozant #dependentlistexcel

Опубликовано:

11 ноя 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 170

@atiqrehman1223 Год назад

Sir, your teaching method is exceptional

@sandeepaswal8944 3 года назад

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

@Innozant 3 года назад

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

@tanvirhussain3074 3 месяца назад

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

@abbaslokhandwala8445 2 года назад

Awesome Training and Examples

@Cagedbutnottamed 2 года назад

Love ur teaching......thanxxxxxx

@madhusudansharma995 Год назад

Excellent Sir . Thank You.

@velocitypta 2 года назад

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

@Innozant 2 года назад

Thanks dear.Keep learning..Keep exploring ❤️

@nikhilkumar988 2 года назад

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

@Innozant 2 года назад

Thanks Nikhil

@pubgs5296 2 года назад

beautifully explained 🙏

@Bhanot01 11 месяцев назад

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.

@keshabgarai8866 2 года назад

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?

@uniquemobiletipstricks7714 11 месяцев назад

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

@Innozant 11 месяцев назад

Really means a lot to me

@govindsharma9121 2 года назад

Sir you are brilliant

@techyfighterbyAftab 3 года назад

👍👍 best teaching methods sir

@Innozant 3 года назад

Thanks Aftab Alarm Ji🙏❤️ for your lovely comment

@user-qr8tc2fj4s 5 месяцев назад

sie very nice teaching plz. reply bundle of thanks

@mahendrakumarvala3046 3 года назад

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

@Innozant 3 года назад

Thanks Mahindra for your valuable feedback ♥️

@uniquemobiletipstricks7714 11 месяцев назад

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

@fawadahmed8869 10 месяцев назад

Bht behtreen sir

@Excelpro75 3 года назад

Very useful sir. Thank you for your excellent explanation.

@Innozant 3 года назад

Thanks dear👍❤️🙏

@boomboomtrade_nse_bse3553 Год назад

excellent. thx a lot

@geetkht84 2 месяца назад

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

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

@khageshprajapati1390 Год назад

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

@Innozant Год назад

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

@AiIsfuture-tj4os Месяц назад

Thanks sir ji❤

@tejpalsain1507 3 года назад

Thanks sir for nice data validation vedio.

@Innozant 3 года назад

Thanks Tejpal Ji🙏❤️👍

@Unfiltered_ind 2 года назад

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

@lawlightplayz4071 2 года назад

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

@Innozant 2 года назад

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

@lawlightplayz4071 2 года назад

I would like admit that I learnt alot watching your RU-vid videos, i sincerely thankyou

@safeerahmed8252 8 месяцев назад

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.

@umeshkumawat3112 2 года назад

Very useful explanation

@Innozant 2 года назад

Thanks dear❤️

@anilkumarparmar1784 Год назад

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

@tarundpatel1 Год назад

Thank you sir ji, you solved my problem.

@Innozant Год назад

Thanks Tarun ji

@sawaimalhi8439 3 года назад

bahot badiaya concept hai sir

@Innozant 3 года назад

🙏🙏🙏

@kinghundred 3 года назад

very good sir

@tjr1421 2 года назад

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

@ilmco4725 2 года назад

Sir I Need some help regarding data validation

@intech6998 2 года назад

Very Nic Very Good

@sadashivkage3133 Год назад

TQ....SIR

@SantoshSahu-ob2mo 2 года назад

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

@asrafshah8568 Год назад

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

@realmex2289 3 года назад

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.

@ukvspk Год назад

Great

@msexcelgooglesheet374 3 года назад

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

@Innozant 3 года назад

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

@shaileshkumar-qf6bd 2 года назад

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

@satishojha6240 3 года назад

Thanku sir I try daily practice good night sir

@Innozant 3 года назад

Good Satish.Gn🙏❤️

@pramodbhavsar4488 3 года назад

Thank you sir I await another datavalidation function

@Innozant 3 года назад

Sure dear👍❤️

@debaldey2061 2 года назад

Very nice very helpful

@Innozant 2 года назад

Thanks Debal

@subratasardar4058 3 года назад

Nice learning video sir

@Innozant 3 года назад

Thanks Subrata..Happy learning 🙏

@rahulkshatriya2786 11 месяцев назад

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

@Innozant 11 месяцев назад

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

@NandKishor-jm1td Год назад

Thnk u

@tarunsehgal5789 2 года назад

Thanks Sir.

@Innozant 2 года назад

Thanks Tarun ji

@SACHiNYADAV-cn1jp 2 года назад

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

@rajveersingh-iw3sb 2 года назад

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

@Innozant 2 года назад

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

@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

@mehndidesignbysushmita8304 Год назад

Sir y prectice sheet download nhi ho rhi

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

@avinashbarge9869 6 месяцев назад

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

@computerforyou5659 Год назад

You are Super love u

@Innozant Год назад

Thanks

@narinderparihar4369 2 года назад

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 2 года назад

Share your query?

@shahnawazdaddi1348 2 года назад

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

@gamesworld_all 3 года назад

Thanku Sir

@Innozant 3 года назад

Thanks Akhil Ji🙏❤️

@sachinkumarsachin9687 3 года назад

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

@Innozant 3 года назад

Shift +F10

@huzaifahshah3841 Год назад

East and west dilp g best

@rhashmi1 2 года назад

very nice

@Innozant 2 года назад

Thanks

@devendergusain8974 3 года назад

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

@Innozant 3 года назад

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

@ravimaurya7093 5 месяцев назад

Sir good morning sir

@bishtlokesh1297 3 года назад

My favourite formula is indirect sir proper Dymnic formula

@Innozant 3 года назад

🙏👍❤️Indirect Pura series aane wala hai dear

@AlimKhan-bl5sh 23 дня назад

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

@gauravbhatia7987 3 года назад

Good

@Innozant 3 года назад

🙏❤️

@saneeshkrishna3818 3 года назад

How to apply the dynamic dropdown list to the below cells

@Innozant 3 года назад

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

@RMKserve 3 года назад

Please include searchable drop down list♥️♥️

@Innozant 3 года назад

sure dear...soon

@meriawaazhindi5217 Год назад

❤️❤️❤️❤️❤️

@kavitagujar2820 Год назад

Bur data list nahi dikhna chahiye uske liye kya kare

@richaverma9986 3 года назад

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 .

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

@ashishkumarjha6731 3 года назад

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 3 года назад

Jhabji source data par hi o dependent drropdown rhta hai na

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

@vaishnavimarwaha8155 Месяц назад

Can you please share the practice workbook

@Innozant Месяц назад

Link in video description

@devokedevtech2750 3 года назад

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 3 года назад

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

@vipintyagi583 2 года назад

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

@Innozant 2 года назад

What erro showing on which kind of data

@vishaldalvi146 2 года назад

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

@Innozant 2 года назад

What prob you are facing there

@devd3499 2 года назад

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

@Innozant 2 года назад

Yes dear

@mahendrakumarvala3046 3 года назад

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 3 года назад

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

@nileshchavan742 3 года назад

👍

@Innozant 3 года назад

❤️🙏

@monikapawar320 3 года назад

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 3 года назад

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

@prashanttyagi1156 3 года назад

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 3 года назад

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

@prashanttyagi1156 3 года назад

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

@nktdilse2596 2 месяца назад

If formula not working sir showing error

@Innozant 2 месяца назад

Office version?

@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

@vishaldhawale3888 Год назад

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

@Innozant Год назад

Ok..noted

@velocitypta 2 года назад

pls upload full power bi course

@Innozant 2 года назад

👍❤️

@msexcelgooglesheet374 3 года назад

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

@Innozant 3 года назад

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

@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

@nitinrautela5561 3 года назад

Hey sir ek query hai apke liye kya ap solve kroge

@Innozant 3 года назад

Ji puchiye🙏

@nitinrautela5561 3 года назад

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

@roshansingh2092 Год назад

Clear image nahi aa raha sir

@Innozant Год назад

Kya issue

@paramjeet975singh3 3 года назад

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

@Innozant 3 года назад

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 3 года назад

@@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 3 года назад

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 3 года назад

@@Innozant thanx sir

@adeshbhadauriya3636 3 года назад

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 3 года назад

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 3 года назад

@@Innozant ok sir

@dqfashionfactory6470 2 года назад

Excel web version video pls

@Innozant 2 года назад

Kindly watch office 365 series for the same

@kumargaurav5644 2 года назад

Source file does not exist

@Innozant 2 года назад

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

@kumargaurav5644 2 года назад

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