Get max value from each day from a range of time using google sheets

Viewed 27

I got this sheet I want to work with : It's a range of many days, minute by minute. Each minute has a value. I want to obtain a list of each day + the minute of the max value (see example in sheet).

It's very similar to this post. I tried to use and apply the solution to my specific sheet, without any success.

I tried many tings, even to simply made the same thing (so without the minute) than in the post I linked, but can't make it to work.

Any hints, explanations or solution will be greatly appreciated :)

1 Answers

try:

=ARRAY_CONSTRAIN(SORTN(SORT(FILTER({A16:A+B16:B\ C16:C\ INT(A16:A)}; 
 C16:C<>""); 3; 1; 2; 0); 9^9; 2; 3; 1); 9^9; 2)

enter image description here

Related