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 limit
please guide me how to solve
In time hours
2 hours + 20 hours = 22 hour
2 hours + 20 hours+ 12 hour =34 hours
1 Reply
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.
