Forum Discussion
smart-IT-up
Jul 04, 2019Copper Contributor
Custom Data Validation
Hi, I'm quite an experienced Excel programmer, but I'm facing a problem with data validation I cannot understand. I got a custom data validation for cell 'K8'. The following formula works perfectly:...
smart-IT-up
Jul 04, 2019Copper Contributor
Well, as a workaround I put the validation formula in a hidden column and referenced in the data validation to it. That works, allthough it's not the clean way...