Questions tagged [data-validation]

Objective: I need to find a way to consolidate multiple home and auto insurance policies purchased by an Insured (aka, policy holder) and assign those policies to a single customer account for that Insured. Problem: I have over 100K+ policy…

I would like to restrict the data in a cell to a numberical 00-00 format with the following requirements: The first and fourth characters need to begin with a "0" or a "1" A hyphen needs to appear as the 3rd character Can anyone help with this…

I am trying to creat a validation that says the date can only be today() + or -7 AND it can not be a weekend. I have gotten the two parts to work seperaTELY but not together. I do not seem to be able to layer one validation on top of the other and…

In this answer's last paragraph, Michael K. says: If you do go the multiple storage media route, too, remember to keep checking each for signs of degredation. It's fairly quick and easy to do a SHA1 hash run over all the files on a drive and…