I was just writing an excel post earlier and was wondering if I’ve seen any from you lately! I’m glad to see that we still retained such a famous excel user on here :) lol
I’ll be dropping mine in here tomorrow!
Data validation was a key component to what I was working on today actually. What appeared to work in my small dataset didn’t work in my big one! I’m glad I validated it with the big one before passing it off as complete. I will give it more analysis tomorrow.
My validation wasn’t like this one though. I am glad you showed this to me! I understand more about some of the forms I fill out and how they set the rules to allow specific entries. I will see if I can find the answer options, sometimes the answers aren’t intuitive and I just free text outside the box lol
Yeps I am still here lurking about, just busy with the kids and family life.
What sort of validation were you working on?
I'm glad you found this post to be of value, the custom data validation is very powerful in Excel if you can master the formulas