Excel - Find MAX Min Value for each day

Can you guys help me finding a solution for this issue?

I have a set of intraday data (15 min data).

How can I ask excel to tell me at what time of each day we reached max and min for that day?

I am trying MATCH INDEX function but my brain does not cooperate....

With MAXIF I can get the max for each day. I am not able to get the corresponding time this extreme was reached.

I attach a set of data.

Thx

Hi kunz78,

this is a simple formula to calculate per day. You can not use more than 1 day because "Time" is the "search key" and must be unique. To make it more simple you can sort the entire table by "High" and then copy/paste and again by "Low" and copy/paste.

Best of luck and stay green always!

Jibala