Excel Custom Data Validation | Use formula to check for text , numbers ,len , Weekday, Pattern

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

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

50% 1

Learn how to apply custom data validation in excel in hindi
1.Apply only text entries
2.Accept value only if it is larger than the previous cell
3. Accepts only non-duplicated data
4. Accept entry only if it begins with A and Accept entry only if it begins with A and contains five characters
5. Accept date entry only if it is a Monday.
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
#customdatavalidation #datavalidationinexcel#Innozant #misinetrviewquestions

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

14 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Masha Allah sir ap bohot great full person hai i really like you sir Allah pak apko kamyabi ki bulandi tak leker jaye meri dua hai dil se ap k liye Ameen.

@KoolCox Год назад

Allah ko sir ke sath likh kar tune sir ki tauheen kar di

@akashkumar-oi1fw 3 года назад

sir apke sikhane ki skill itni acchi hai ki lagta hi nahi aap dur ho aisa lagta hai aap ek dum samne hi ho or saare doubts clear kar dete ho

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

Thanks Akash Ji❤️🙏itne pyare comment ke liye ..HV a great day

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

thanks sir ji aur aapko aur apke parivar ko bhi dhanteras aur choti dipawli ki hardik shubhkamnaye.

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

Thanks dear🙏❤️

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

For LargerthanPrevious formula would be if(a1"",if(a2>a1,a2)) Thankyou Sir for these wonderful classes

@kcs-dj3ec 3 года назад

Sir, I like your delivery style. I learnt so much from your educational videos on mobile. I want a small change. On mobile the cells or formula bar needs expanded as the formula entered is not visible. Pl. Make your talking picture Small and formula bar larger. It will help us a lot.

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

Ok..Will take care in future

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

bhot acha smjhate ho sir thnx sir

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

Thanks Devender ji..Happy learning

@1gopalakrishnarao 3 года назад

Excellent. In every video, your explanation, ideas, tricks are very informative, & most useful for the practical Excel Users/learners/addicts/lovers. You are a lighting lamp for the Excel interested persons. Thanks a lot. Happy Diwali.

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

Happy Diwali Gopala Sir.❤️🙏

@1gopalakrishnarao 3 года назад

@@Innozant Thank you wish you & viewers/learners the same.

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

Sir Today I learned new lecture. You are very mindblowing. Aapkai ek ek concept ka samjanai ka tarika bahut hi greatful hai. Aapkai har videos sai mainai nayi chiz shiki hai. Wish You Happy Diwali Sir ji.🎁🎊

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

Thanks Sandeep Ji❤️🙏Happy Dhanteras

@Generalaladdin3616 Год назад

Sir your Video helps me a lot You taught me many things of data validation thanks a lot your video helps me a lot

@Innozant Год назад

Thanks

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

What a Coincidence today I m watching this video and today is also Dhanteras...Happy Dhanteras Sir 🙏🙏

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

Hahaha.. Thanks Dear..♥️♥️Aapko bhi Diwali ki dher saari shubhkamnayen

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

mere dost (M Ashir) nay sahi kaha tha k ap bohot nice person hai aur excel master bhi, is man koi shak nahi hai.

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

Thanks Saqlaij sahab apke valuable appreciation ke liye

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

sir ap thanks na kahay Q k ap bohot qabil person hai bus meri dua hai Allah tala apko be shumar izzat de you are honest person i really like you.

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

very useful & practical concept app ne discussion karte ha Sir, thank u Sir

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

Thanks dear

@kamrankhan-hh9jv 3 года назад

Dear Sir , i am growing up in my career thru your advance Excel video i Request to you create one project where we will create from scratch Design Erp on Excel inventory management system, Sales purchase and trial balance ,balance sheet and profit and loss by your advance skill tips and trick

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

Thanks Kamran...Thanks ❤ for your suggestions..noted 🙏

@shrikantbadge3978 Год назад

Amazing tutorial. Thank you Dilip sir.

@deepakkandpal2602 Год назад

thank you sir, i really appreciate your work.. the way you teach us that's really amazing. Thank you again.🙏🙏🙏

@Innozant Год назад

Thanks dear

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

You are very sincere to your profession ❤️❤️❤️♥️

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

Thanks Rizwan..Gn

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

Wonderful...after watching alot of video now I can understand data validation from your video...your teaching skill is really really different from other's...please carry on...

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

Thanks Amulya for your valuable appreciation..God bless You ❤️

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

@@Innozant you most welcome, one request ,though I have seen a lot videos regarding pivot table on youtube even from your channel too but still I have doubt with pivot table so I request to make more videos regarding pivot table,thank you so much for educate me for educate india...

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

@@amulyaroutray6324 thanks

@deepakkandpal2602 Год назад

sir i have a question, ye jo larger value wala question kraya hai apne jisme hame previous se larger value chahiye next cell mai. to isme hme har 1 cell par ja k formula apply krna hoga..? please clear my doubt.

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

Excellent, the way you explain and the practical question.

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

Thanks Jishaya,We welcome you to experience the taste of success. Happy Diwali to you and your family.❤️🙂🙏

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

Super way of making understand. Thank You. Awesome video

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

Thanks dear .. Really means a lot to me

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

@@Innozant Most Welcome Sir.🙏

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

THANKS SIR, PAN NO KE LIYE CUSTOM (FORMULA) DATA VALIDATION ME KYA HOGA

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

Very nice video of datavalidation with custom function thank you sir. Happy Dipawali and New year and God bless you healthy and progressive life thank you.

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

Thanks Pramod for wishes. Happy Diwali to you and your family.🙏❤️

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

You are the best sir ❣️

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

Thanks Sohail ju

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

In larger than previous can't we use relative referencing or we have to do it individually for each and every cell, what to do in bigger range?

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

👍🙏 one query plz when we copy data from other location to data validation area...it accept any type of data without any error ...

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

Like..?didnt get you

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

धनतेरस की हार्दिक शुभकामनाएं।

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

Aapko aur apke parivar ko bhi Dhanteras ki shubhkamnayen

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

Sir your teaching skill quite unique.

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

Happy Diwali Hemant ❤️🙏

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

@@Innozant same to you sir

@Muhammadarifkhan. 3 года назад

Excellent sir great work love from Pakistan.

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

Thanks dear

@Muhammadarifkhan. 3 года назад

@@Innozant thank you for your response here.

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

Thank u so much sir 🔥❤️

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

Very well explained

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

Thanks dear

@asharfali9029 Год назад

When the use countif and Use A????character but not pickup the below cell how to do this please solve

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

Very useful n amazing

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

Super formula excellent sir

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

Excellent Tutorial I have ever seen

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

Thanks Nurul Haque Sahab for such a valuable feedback..We welcome you experience the taste of success with Innozant-Seed of success.. Happy Learning.👍❤️🙏

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

Thanks Sir, well explained.

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

thanks a lot sir for your response.

@sameermathur9927 Год назад

Absolutely brilliant

@Innozant Год назад

Thanks Sameer ji

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

Ek number bhai 😭👍❤️

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

Thanks dear❤️🙏

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

Happy diwali sir

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

Happy Diwali to you and your family.🙂

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

@@Innozant thanks sir

@LetsLearnEnglish-tk9sw 26 дней назад

Thank you so much sir❤

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

Without using VBA how to control check box form control ,that means out of multiple check boxes only one selection is allowed

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

can you guide me apply data validation list option but that list not entry in sun

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

Great sir 👍 have a good day

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

Thanks Ram.. Happy Dhanteras

@mustafmulani7597 Год назад

Hi sir Excel me muje ek name ki list he uske aye uska service type ana chaheye name aya ki service type chenge hona cheye

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

Sir, begins with A and contains 5 characters wala question mere excel version me kaam nahi kar raha, bimlesh likhne par error nahi dikha raha. mera excel 2013 hai. Formula bhi check kiya same apne bataya vaise hi kiya phir bhi nahi hora.

@awanishanurag1763 Год назад

Sir What if Analysis aur Goal Seek Scenario par bhi ek content banaiye!!

@Innozant Год назад

Already Play list bana hua hai what if analysis

@prakashkumar-wv2mo 3 года назад

If we type duplicate value, it prevents, but if we copy duplicate value from other sheet and paste on data validation range, then they accept duplicate value as well. If any solution pls answer 🙏

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

Thanku so much sir waiting for next video of data validations and Happy Diwali in advance good night sir.

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

Happy Dhanteras dear.Good Night❤️🙏

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

very good sir

@nasarkapoor9815 Год назад

Excellent

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

sir Non duplicate data ki range agar dynamic karni ho to kya use kare gy

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

Using offset

@farhanjabbar1116 Год назад

Great hats off 🎉🐎🐎🐎🐎🐎

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

Happy Diwali sir

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

Happy Diwali to you and your family

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

so so thanks to you .

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

Sir is it possible if I Put A the result should give 06:00 to 14:00hrs

@mohitech5766 Год назад

Accept entry only it it begins with A =Find(A1(within text), A, (text), 1(Start number)) =1

@srinivasbattula1863 Год назад

I can't understand why are u not getting more views.

@Innozant Год назад

Even I can't understand 😊lagta hai Jadoo wale video hi audience ki jyada pasand short cut method no one is interested to learn things deeply 😊

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

Hello sir..di you have full video of Basic excel and Advance excel

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

Visit Innozant website for Mastering Excel Paid Video Course

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

Excellent 👌👌

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

Thanks 🙏❤️

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

Sir, data validation me duplicate wala rules copy paste me kaam nahi karta kya? For example:- ek new sheet me kuchh no. Already hai jo old sheet se copy karke laa rahe hai. Wo error nhi deta keval type karne par hi deta hai error.

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

Duplicate rules?

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

Duplicate rules?

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

@@Innozant duplicate no. Pakad le type nahi karna copy paste karna hai. Data validation or conditional formatting both se. One sheet to another sheet me.

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

Thank you very much sir

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

Thanks Akhil Ji..Happy Dhanteras 🙏❤️

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

Sir,I am interested in excel core, advance course what will be cost & duration

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

sarohaair2015@gmail.com

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

Ok..will send you details in your mail id.

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

Course details mail sent.. kindly check

@tejnthakur6886 Год назад

very good

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

Wow sir amazing

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

Sir please make a vedio on complete ms access

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

Be quick

@ChandanKumar-gp8zw 2 года назад

Thanks Sir

@Shorthandwithsunitainm.v.3 Год назад

ACCEPT VALUE IF GREATER THAN PREVIOUS VALUE (I AM UNABLE TO USE FORMULA FOR ALL SELECTED CELLS). It is working only for single cell at a time. Please give solution for the same.

@ManishKumar-f3w4f Год назад

some part is hide by creator not useful vdo

@Rvkvlogs_arora Год назад

Which type of farmula we can use if we have number’s of names and we need to choose only last name which is “singh”. Like mark yes if person is singh otherwise no. Please give some example on this.

@Thelatestdesigner Год назад

Nice sir

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

Sir when I put in Excel sheet any word or digit result show custom format like w2022,then we open new Excel sheet and put any number or digit also show w2022, please solve problem

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

Didnt get your query ..kindly explain

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

@@Innozant जब हम कुछ भी अंक या शब्द एक्सेल में लिखते है और इंटर करते है तो ऑटोमैटिक एक ही text लेता है जैसे यदि हम राम लिखे और इंटर करे तो ऑटोमैटिक w2022 लिख कर आता है यदि न्यू एक्सेल शीट ओपन करते है और राम या कुछ भी लिखते है और इंटर करे तो वही w2022 ही लिख कर आता है जैसे कस्टम फॉर्मेट बनाते है वैसा ही हो रहा है इसी जैसा ms word में भी हो रहा है कृपया समस्या का समाधान करें

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

How can we combine two data validation formula for one cell, excel is allow only one formula at a time My condition is = no double entry in colume and second is 2 text and 4 number in the cell, Can you make a videos on this topic

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

Ok..noted

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

Happy Diwali Sir.... if 0 is sunday then 1 should be monday but in this exmple you take 2 for monday..?

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

Dear 0 is not Sunday..Week Ka pehla din 0 Nahi 1(Sunday) hota hai😀.i.e. 1 -sunday,7-sat Happy Diwali to you and your family ❤️🙏

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

Aap ke attendence shhet pe ek video bana dijiye jo fully automatic ho plz

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

Ok . noted...give me some time dear..yaa d rhega mujhe

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

Thanks

@AMITCHAUHAN-ol1hv 3 года назад

Sir aapka ka office kha hai

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

SIR IF I WANT TO RESTRICT FOR BLANK CELL FOR VALIDATION WHAT WIL BE THE FORMULA..

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

Null pass kr dijiye..""

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

Nice video

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

❤️ Thanks

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

But if we use formula as @ 2:22 And now if anyone try to enter numeric mix text in (TEXT ONLY DATA VALIDATION CELL) it except it Like a4bc or abc3 Now the big Question is that how to prevent " NUMERIC MIX TEXT " entry in these cells

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

Awesome

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

❤️🙏 Thanks

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

jai ho sir

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

🙏🙏🙏

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

Sir, please suggest below comments...

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

If text and number both update karana hai to

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

Use and function outside

@divyanshugupta6187 Год назад

Name formula lagane me.. Agar mai name k sath number bhi likhra hu.. To koi error nh dikhara.. Please help..

@salmanibhai5843 4 дня назад

sir countif vale fomula kaam nhi ke rha hai

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

Thank sir

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

Thanks Gaurav..🙏❤️m happy...ajakl aap bht dedicated hoke study start kiye h

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

@@Innozant ji sir main apke sabi tutorials dekhuga day bay day because ex.. Different hai video main aur formula muje bht helpful lage sir thnq

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

Thanks..Aab step by step dekhna playlist..random nhi...usse achese samjh aayega

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

HAPPY DIWALI DEAR SIR, VERY INTERESTING CONCEPT AND VERY INTERESTING IN LEARNING 🙏🙏🙏🙏 Pranam Gurudev

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

Happy Dhanteras dear❤️🙏

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

@@Innozant SIR WHERE ARE YOU FROM?

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

Sir M.S excel mei koi new addition hua ho to uski video hum dekhna chahte hain.

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

Jaroor bnayenge aur bna rhe hain new finctions updates

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

@@Innozant Thank you sir

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

also, how to link desired formula in drop down list

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

@meriawaazhindi5217 Год назад

❤️❤️❤️❤️

@AP-gr4ij Год назад

Sir agar 3ya 4 le tab kya karen

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

Date would not accept Sunday.. Isko kayse kare. Plz tell

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

Using weekday(date)1

@gaureeshankarsharma2930 Год назад

🙏🙏

@RahulChauhan-ll9pu 3 года назад

🙏

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

🙏❤️

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

Sir pichli video me ap ne sunday k liye 1 likha. magar yahan ap keh rahy hain sunday 0 hai. mjhy samajh nahi aai

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

Hassan sahab pichli video me kis situation me 1 bola tha eo baar vidoe dekhen..weekday function use krte time sunday 1 aur sat 7 consider krte h jba default lenge to

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

⭐⭐⭐⭐⭐

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

🙏❤️

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

Thanks sir. मेने डाटा वेलिडेशन को सॉल्व करके आपको व्हाट्सएप तथा टेलीग्राम पर सेंड कर दिया है। आप चेक कर लेना सर। धन्यवाद। आपके और आपके परिवार को दीवाली की हार्दिक बधाई।🌷🌷🌷🌷🌺🌺🌺🌺🙏

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

Haan .Mila gya hai mujhe..apka solved assignment.❤️🙏Happy Dhanteras