Hi!, to be honest i have only used data validation to make lists! the use of custom as a validatation criteria is certainly new to me, but very, very useful indeed! you have a new subscriber!!!
I was impressed by the methodology of your presentations let alone its content! One can learn the power of excel and how to right complex formulas (e.g. in the last example on how to prevent double booking of a meeting room). THANKS!!!
Thank you for the wonderful feedback! I'm glad you found both the content and the presentation style helpful. I always aim to apply real-life problems in my videos to make Excel’s powerful formulas more relatable. Appreciate your support and stay tuned for more! 😊
Thanks a lot! I'm glad you found the video helpful. There’s so much more you can do with it! If you’re interested in more Excel tips, stay tuned for future videos. 😊
your instruction regarding this special use of data validation is very useful for me . I have been looking for the possibility of customized data validation by using a formula for some time. No I'm happy to get the solution ! Thank you very much !
Thank you so much for your kind words! I'm really glad that the data validation tutorial was helpful for you. I truly appreciate you taking the time to share your feedback.
I'm glad that you liked it.. Check out my another video on 6 Advanced use of SORTBY Function.. th-cam.com/video/BpRZ3i9HOWk/w-d-xo.htmlsi=sCkKNcbS1nRbPMwI
Haha... this is such a personal touch! Yes, you can absolutely add that validation too. You can do this by adding another column for the meeting time and then modifying the data validation formula for the meeting room. To ensure that the next meeting can't be booked if it's less than 1 hour before the end of the day (assuming your office time ends at 18:00), you can additional condition like this F2
Hi!, to be honest i have only used data validation to make lists! the use of custom as a validatation criteria is certainly new to me, but very, very useful indeed! you have a new subscriber!!!
Awww🥹🥹.. Thank You So Much.. Also, checkout my Basic Data Validation video on my channel...
I was impressed by the methodology of your presentations let alone its content! One can learn the power of excel and how to right complex formulas (e.g. in the last example on how to prevent double booking of a meeting room). THANKS!!!
Thank you for the wonderful feedback! I'm glad you found both the content and the presentation style helpful. I always aim to apply real-life problems in my videos to make Excel’s powerful formulas more relatable. Appreciate your support and stay tuned for more! 😊
What a fantastic video, best and most practical, useful and dynamic use of validation rules I’ve seen on You Tube, thank you.
Thank you so much for the wonderful feedback! I'm really glad you found the video practical and useful. 🫰🫰
Great video. Like several others here I havee only used data validation for drop down list. Not any more. Thanks
Thanks a lot! I'm glad you found the video helpful. There’s so much more you can do with it! If you’re interested in more Excel tips, stay tuned for future videos. 😊
This is so useful.. I didn't know that we can use data validation like this also.. Thanks again..
🤘🤘
Thank you for sharing 🙂
I'm glad that you liked it..😀
Thank You for all the tricks especially the last one!
I'm glad that you liked it... :)
So informative
Thank you so much.. :)
your instruction regarding this special use of data validation is very useful for me .
I have been looking for the possibility of customized data validation by using a formula for some time. No I'm happy to get the solution !
Thank you very much !
Thank you so much for your kind words! I'm really glad that the data validation tutorial was helpful for you. I truly appreciate you taking the time to share your feedback.
Thank you so much for such invaluable and informative content. 🙏
I'm glad that you liked it.. Check out my another video on 6 Advanced use of SORTBY Function.. th-cam.com/video/BpRZ3i9HOWk/w-d-xo.htmlsi=sCkKNcbS1nRbPMwI
Great
Thanks :)
Informative
Thank you so much ☺️
Could you please do the Data Analysis on Real Estate Project.
👍👍
❤
🫶🫶
If this data is put into table format the validation updates when data size increases
if this validation is in table format, it will update with table
It's a good video kindly share details course of power query from scratch
Thank you so much..
can you please mention Formula here in (metting date-Col E) , time has also to be mentioned and next meeting cant be booked if it is
Haha... this is such a personal touch! Yes, you can absolutely add that validation too. You can do this by adding another column for the meeting time and then modifying the data validation formula for the meeting room. To ensure that the next meeting can't be booked if it's less than 1 hour before the end of the day (assuming your office time ends at 18:00), you can additional condition like this F2
I like this video. The AI voice is hard to listen to though.
Glad that you liked the video.. And thanks for the feedback 🫰🫰Appreciate it!