Validating data extracts

Posted by / 20-Jun-2017 19:35

Validating data extracts

Guidelines for the validation of DNA extraction methods especially in the scope of the analysis of genetically modified sequences in food and feed products by real-time polymerase chain reaction (real-time PCR) are described.

If the two substrings match exactly, the formula returns TRUE and the validation passes; otherwise FALSE is returned and the validation fails.

To limit the entry to a date within a specified range, you can use either the predefined Date rule with the "between" criteria or make a custom validation rule with this generic formula: Please notice that the boundary dates are locked with absolute cell references.

To restrict a user to entering only weekdays or weekends, configure a custom validation rule based on the WEEKDAY function.

In yesterday's tutorial we started to look at Excel Data Validation - what its purpose is, how it works, and how to use built-in rules to validate data in your worksheets.

Today, we are going to take a step further and talk about the nitty-gritty aspects of custom data validation in Excel as well as experiment with a handful of different validation formulas.

validating data extracts-68validating data extracts-26validating data extracts-36

One thought on “validating data extracts”