Forum Discussion
Autofill large increment
Hello I have two questions regarding the same spreadsheet. Let me make a small example first: A B C D ...
Sanjyn81 First we create a new column (C) with the date of the date-time column, with this formula:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Then we find the maximum using this formula:
=MAXIFS($B$1:$B$72,$C$1:$C$72,E1)
Then we can find the associated time where this maximum occurred using the following formula:
=XLOOKUP(F1&E1,$B$1:$B$72&$C$1:$C$72,$A$1:$A$72)
I made a custom video explaining how to apply these formulas in your case: https://www.youtube.com/watch?v=A14HPBmHcp4
Optional tip if this was helpful: [link removed by admin]
This worked super great, thanks.