Forum Discussion
Validate the data logger data
Here the data is downloaded from the data Logger We want to check the pass or fail Allowable limit is given below the picture Is it possible to check the readings are within the limit or out of li...
In Excel, use Data → Data Validation to set the range, you can also use Power Query's = Table.ReplaceErrorValues (source, {“Column Name”, null}) to clean up the abnormal values, all of which can verify the data depending on your choice.