Forum

Thanks Phil, That makes sense. I realise now though that I haven't asked my question correctly! Maybe what I'm after is correctly called a mo...

Ok, so here’s what I came up with. First, I made a pivot table with the date in rows and time (hours) in columns. Max of high was used for values. ...

2nd attemp!