fooj
05-07-2009, 09:12 AM
I have had a stack of data sent through to me with a series of values recorded hourly over 5 years.
I wanted to try write some code that would look at the values for each day and pick the min and max for that day and paste them into another sheet.
The current data format is as below
Date Time Value
05/06/2009 12:00 69
05/06/2009 01:00 71
05/06/2009 02:00 70
Does anyone have any ideas on how I could achieve this?
Thanks
I wanted to try write some code that would look at the values for each day and pick the min and max for that day and paste them into another sheet.
The current data format is as below
Date Time Value
05/06/2009 12:00 69
05/06/2009 01:00 71
05/06/2009 02:00 70
Does anyone have any ideas on how I could achieve this?
Thanks