How to use Custom Data Validation in Excel

[@jacinthandrew]

This is very useful, thank you , pls advise if there is a way to replace a one with a word ?

[@pradyumnasatapathy321]

This is so wonderful, and your explanation is great. Thank you

[@mohamadraffi8260]

Very helpful content. Thank you Mr.Ram Gopal Ji

[@PresentationProcess]

Good to know...

[@merine7420]

You're the best..thanks

[@abduljabbarkhan9107]

Very well described. Learnt a lot.

[@vitietajonera4159]

Very informative! Thanks!

[@PresentationProcess]

Glad it was helpful!

[@georgeregoo]

Excellent. But what about entry of a mix of character and Numeric (example a part No)

[@sangeetabhatnagar738]

Great work..thanks for sharing

[@moodkn]

So Nice... Thanks1

[@SRT0202]

Appreciate your simplified explanation. Could you also please make simplified videos on pivot tables and power querry in excel. Thank you.

[@PresentationProcess]

Thanks for the suggestion!

[@javedahmed8343]

Nice explanation

[@rcnethreshgowda6347]

Sir if there are any criteria's means we can use some if or sumifs function right then why we are nor using sumif or sum ifs for custom data validation ?

[@alesachmad9486]

Good👍 Go on

[@PresentationProcess]

Thanks! Appreciate your support!

[@nature7751]

very helpful

[@maheshmurugan571]

Can you make a video , which is based on OFFSET .

[@olufemiolawale3848]

Thank you in bunch!

[@habibahimu1431]

Thanks a lot sir..

[@archanaaa2514]

Sir. How to use data validation for duplicate list?

[@ashvinkalleejaisriram]

I want to validate each cell that none can be blank. How to do same

[@abuisakhodadad4663]

great

[@Nold47]

Thank you.

[@sudhan9152]

Great ! but this validation is not in special paste scenario.

[@Pakidesivlog]

Today()
2*b2
Istext()
Isnumber()
AND(istext(),(len()

[@rajashekarshekar5585]

Address