Fortunately, you can automate this task using Data Validation tools. I have created an example spreadsheet ... A video demonstration of this process is available at the bottom of this article. Do you ...

According to the United States Food and Drug Administration (FDA), process validation is collecting and evaluating data obtained throughout a product's entire lifecycle, including the initial drug ...