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

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
Download the Assignment Master Practice Folder here (All Playlist Example at one place)

Let's Connect:
#customdatavalidation #datavalidationinexcel#Innozant #misinetrviewquestions

[muhammadsaqlain]

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.

[akashkumar-oifw]

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

[msexcelgooglesheet]

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

[innovativerupan]

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

[nitesharekar]

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

[Generalaladdin]

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

[RMKserve]

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

[shrikantbadge]

Amazing tutorial. Thank you Dilip sir.

[deepakkandpal]

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

[ayanmallick]

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

[Jishayaful]

Excellent, the way you explain and the practical question.

[VBBasicLearning]

Super way of making understand. Thank You. Awesome video

[sandeepaswal]

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.🎁🎊

[amulyaroutray]

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

[gopalakrishnarao]

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

[kamrankhan-hhjv]

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

[muhammadsaqlain]

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

[kcs-djec]

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.

[Muhammadarifkh]

Excellent sir great work love from Pakistan.

[mohitech]

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