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
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
Attached File(s)
test.txt
33 KB
|
157 downloads