Forum Discussion

Aditya Jadhav's avatar
Aditya Jadhav
Brass Contributor
Feb 10, 2018
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...
Formulas
Formulas & Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 10, 2018

    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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 10, 2018

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 Jadhav's avatar
    Aditya Jadhav
    Brass Contributor
    Feb 12, 2018

    Hi SergeiBaklan,

    Thank you for the suggestion and it has helped me a lot.

    Hi Haytham Amairah,

    The data that i have put up here doesn't have missing data that i know just wanted to know the way to find it out as i have the data which contains 6 years back data and just wanted to check all of that.

     

    Regards,

    Aditya

Resources