Search points and find if the point has at least 1 reading every hour.

trev999

New Member
Joined
May 15, 2014
Messages
1
Hello people.

Can you help with this problem I have been stuck on for quite a while now.

My data set consists of 2 columns: A - the points name (of which there is about 11)
B - date and time (DD/MM/YYYY HH:MM:SS) (should be every 15 minutes, multiples of 15: 00, 15, 30, 45)

the data set is a whole month

So, each point should have a date and time every 15 minutes, however, sometimes this does not happen. The minimum is that every point should have at least 1 reading every hour.
Is it possible to be able search the whole dataset and find which points do not have at least 1 reading every hour and if it doesn't return which point and the date and time?


Thanks guys, appreciated


example of data -
Point 131/03/2014 23:45
Point 131/03/2014 23:30
Point 129/03/2014 19:15
Point 129/03/2014 19:00
Point 118/03/2014 15:30
Point 118/03/2014 15:45
Point 108/03/2014 19:30
Point 108/03/2014 19:45
Point 108/03/2014 20:00
point 209/03/2014 14:30
point 209/03/2014 14:45
point 209/03/2014 15:00
point 209/03/2014 15:15
point 201/03/2014 02:15
point 201/03/2014 02:30
point 301/03/2014 03:30
point 301/03/2014 03:45
point 301/03/2014 04:00
point 301/03/2014 04:15
point 320/03/2014 22:30
point 320/03/2014 22:45

<tbody>
</tbody>




<tbody>
</tbody>

<tbody>
</tbody>
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top