Min and Max by date

[Soren]

Hi, I am trying to get the Min and Max electricity meter reading by date. The data returns meter a reading every 15 minutes for 24 hour period. File spans 6 months of data.
Something like "get min and max from array, for each unique date" and then return the time of each of these returned result.
Data is sorted by date and time.
Date in column E, Time in column F, Day in column G and reading in column H.
I am not VB literate

Please help if this is even possible

regards

Soren

 

[CSmith]

Can you supply a small sample?

 

[DanteAmor]

You can create a pivot table for maximum values and another pivot table for minimum values:

 

[Soren]

Thanks, I will try the pivot table, many thanks

 

[DanteAmor]

Of course, let me know any doubt