Forum Discussion
Solved
How to find the missing values from a data ?
Hi,
Actually trying to figure out how to find the missing data from a data set. Have a data set which contains two columns, one has dates and the other one has time. Now i want to find if the h...
Hi Aditya,
You may add Pivot Table with count of time as values and filter the value if it less than 24. Result will be list if dates for which some time missed.
If, in addition, add Time to columns you'll see which exactly times were missed.
Aditya,
There are no missing hours, each date corresponds to a time starting from 0:00 (12:00 AM) until 23:00!
To check for that, press the filter arrow of the time column and take a look at the filter list to see if there are blank cells.