Need corresponding hourly values (24per day) daily from multiple [Closed]

Report
Posts
1
Registration date
Monday July 27, 2015
Status
Member
Last seen
July 27, 2015
-
I need a formula which will select data automatically from raw data sheet considering to near by (Corresponding) every hour duration. There should be not adding or average of one hour duration data.e.g:-
if i have following data :-
Date & time Value
6/30/2015 23:55 4
6/30/2015 23:35 3
6/30/2015 23:19 6
6/30/2015 22:59 5
6/30/2015 22:44 8
6/30/2015 22:24 3
6/30/2015 22:09 8
.
.
.
6/01/2015 23:09 7
The result should be in another sheet :-

6/30/2015 24:00 4
6/30/2015 23:00 5
6/30/2015 22:00 8
.
.
.
6/01/2015 23:00 7
I need only 24 readings per day on hour basis from raw data without adding or averaging at that duration data. The Problem is raw data is in random form i.e we are getting 2 data sets/hour,3 data sets/hour,4 data sets/hour so i am not able to pick alternate values or nth value in sheet.

I want to develop a sheet in which i want to paste data in raw data sheet i will get result data in dashboard sheet.


with regards,
Arun

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!